how to show toolbar in google sheets

Show Google Sheets Toolbar in a Snap

By Ashley White
AD

Ever found yourself squinting at tiny icons in Google Sheets, wishing you could see toolbars more clearly? Google Sheets has introduced a new feature, enabling you to show and hide toolbars with ease. Let's dive into how to make the most of this functionality.

Google Sheets offers various toolbars packed with useful features. From formatting to drawing, editing to reviewing, having these toolbars visible can enhance your productivity significantly. So, let's discover how to show toolbar in Google Sheets.

Understanding Google Sheets Toolbars

Google Sheets comes with several toolbars, each offering a set of features. Familiarizing yourself with these will help you navigate your spreadsheets more efficiently. They are:

AD
a laptop with google sheets on it and the words google sheets for teachers above it
a laptop with google sheets on it and the words google sheets for teachers above it
How to Create Progress Bars in Google Sheets (Step-by-Step)
How to Create Progress Bars in Google Sheets (Step-by-Step)
Basic Formatting in Google Sheets
Basic Formatting in Google Sheets

- Formatting toolbar: edited with fonts, text alignment, fill, border, and more. - Drawing toolbar: used to insert shapes, lines, and images. - Review toolbar: for track changes, comments, and suggesting changes.

Identifying Toolbar Icons

The icons on the toolbars represent different functionalities. Here are a few key ones:

Google Sheets Tip to Create Language Vocabulary Lists | Teacher Hacks | Twinkl UK
Google Sheets Tip to Create Language Vocabulary Lists | Teacher Hacks | Twinkl UK
The Ultimate Google Sheets Keyboard Shortcut Cheat Sheet for Beginners & Pros
The Ultimate Google Sheets Keyboard Shortcut Cheat Sheet for Beginners & Pros
  • Font - Changes the font type.
  • Bold/Italics/Underline - Styles text.
  • Align - Aligns text.
  • Fill color - Fills cells with color.
  • Border - Adds border to cells.
  • Comment - Adds a comment to a cell.
  • Track changes - Enables track changes feature.

Showing and Hiding Toolbars

Google Sheets allows you to show or hide these toolbars as per your requirement.

  1. To show a toolbar, click on View in the menubar, hover over your desired toolbar, then click on Show [Toolbar Name].
  2. To hide a toolbar, follow the same steps but click on Hide [Toolbar Name].

Customizing Your Google Sheets Workspace

Google Sheets goes a step further by allowing you to customize your view further.

AD

By default, some toolbars are hidden. You can show or hide these in the Customize... menu under View. This menu also allows you to add or remove items from your toolbar.

Resizing and Moving Toolbars

To optimize your workspace, you can also resize and move your toolbars.

  1. Resizing: Click and drag the edge of the toolbar to resize it.
  2. Moving: Drag the toolbar to your desired location. It's useful to place them beside your main workspace for easy access.

Now that you know how to show toolbar in Google Sheets and customize your workspace, it's time to leverage these features to boost your productivity. Happy spreadsheeting!

AD
AD