8/5/2021

Quick Access Tool Bar In Excell 2013 For Mac

40

Work paceteach to be happy. To ease your transition to Excel 2013 from Excel 2003, you can customize the Quick Access Toolbar so that it contains every button from the Standard and Formatting toolbar in Excel 2003 with the exception of the Permission, Drawing, Zoom, and Help buttons. How to Customize the Excel 2013 Quick Access Toolbar. Quick Access Toolbar in Excel 2013. Quick Access Toolbar is Located just above the Ribbon. It let you access the most general & common commands. By default, Quick Access Toolbar in Excel 2013 includes Commands like, Save, Undo, and Repeat. Yes of Course you can add other commands to Quick Access Toolbar depending on your preference.

What is the Quick Access Toolbar?

The Quick Access Toolbar is a set of icons that allows you to easily access the commands you use the most. By default the quick access toolbar only contains 4 commands but the commands it contains can be customized to suit the user.

  1. Save allows you to quickly save a file.
  2. Undo allows you to quickly undo the last command or action that was performed in the workbook.
  3. Redo allows you to quickly redo the last command or action that was undone in the workbook.
  4. Mouse/Touch Mode Toggle (only for touch screen devices) allows you to toggle between a mouse mode and a touch screen mode. In touch screen mode, commands in the ribbon are more spaced out so they’re easily accessed by touch.

Changing The Quick Access Toolbar Location

If you don’t like the default location above the ribbon then you can move the Quick Access Toolbar below the ribbon.

  1. Click on the small down arrow to the right of the Quick Access Toolbar to open the drop down menu.
  2. Select Show Below the Ribbon from the menu.
  3. Now the Quick Access Toolbar displays underneath the ribbon.

These are the only two places the Quick Access Toolbar can live and it’s restrained to being left aligned in both cases.

Adding Commands To The Quick Access Toolbar

You can add commands to your Quick Access Toolbar and you’re not restricted only to commands that appear in the ribbon, you can also add commands that don’t appear in the ribbon.

  1. Click on the small down arrow to the right of the Quick Access Toolbar to open the drop down menu.
  2. There is a selection of 12 common commands, including the 4 default commands, that can be added to the Quick Access Toolbar by checking them off in this menu.
  3. To choose from all of Excel’s available commands select More Commands from the menu.
  4. Select an option from the Choose commands from drop down menu. Commands are organised in several useful fashions, or you can choose to view All Commands.
  5. Select a command which you want to add to the Quick Access Toolbar.
  6. Press the Add button. You can also remove commands with the Remove button.
  7. Use the Up or Down arrow to rearrange the order of the Commands in your toolbar.
  8. Press the OK button.

Removing A Command From The Quick Access Toolbar

Removing a command from the Quick Access Toolbar is easy.

  1. Right click on the command you want to remove.
  2. Select Remove from Quick Access Toolbar from the menu.

Use Your Quick Access Toolbar Commands With Keyboard Shortcuts

If you like using keyboard shortcuts, you can use the commands with Alt + Number(s) keyboard shortcut. After pressing the Alt key, the numbers associated with the commands will be shown.

Watch Video – 3 Ways to Select Visible Cells in Excel

What do you do when you have to copy a range of cells in Excel and paste it somewhere else?

In most cases, the below three steps get the work done:

  1. Select the cells that you want to copy.
  2. Copy the cells (Control + C).
  3. Select the destination cell and paste these cells (Control + V).

But what if you have some hidden cells in the dataset?

Then – these above three steps are not enough.

Let me show you what happens when you try to copy cells that have hidden rows/columns in it.

Suppose you have a dataset as shown below:

Note that there are hidden rows in this dataset (look at the row numbers).

Now see what happens when I try to copy these cells and paste it somewhere else.

In the above example, I selected the visible cells, but when I paste these cells into another location, it copied the visible as well as the hidden cells.

The workaround to this is to make sure that Excel only selects the visible cells. Then I can copy and paste these visible cells only.

In this tutorial, I will show you three ways to select visible cells only in Excel.

Select Visible Cells using a Keyboard Shortcut

The easiest way to select visible cells in Excel is by using the following keyboard shortcut:

Quick Access Tool Bar In Excell 2013 For Mac
  • For windows: ALT + ;(hold the ALT key and then press the semicolon key)
  • For Mac: Cmd+Shift+Z

Here is a screencast where I select only the visible cells, copy the visible cells (notice the marching ants around selection), and paste these:

Select Visible Cells using Go To Special Dialog Box

Quick access tool bar in excell 2013 for mac catalina

While using the keyboard shortcut is the fastest way to select visible cells, if you don’t want to use the keyboard or don’t remember the shortcut, there is another way.

You can use the ‘Go To Special’ dialog box to select visible cells in a dataset.

Here are the steps:

  1. Select the data set in which you want to select the visible cells.
  2. Go to the Home tab.
  3. In the Editing group, click on Find and Select.
  4. Click on Go To Special.
  5. In the ‘Go To Special’ dialog box, select ‘Visible cells only’.
  6. Click OK.
Download

This would select all the visible cells in the dataset.

Select Visible Cells using a QAT Command

Another great way to select visible cells in Excel is to add a command to the Quick Access Toolbar (QAT).

Once added, you can simply click this command in the QAT, and it will select visible cells in the dataset.

Here are the steps to add ‘Select Visible Cells’ command to the QAT:

  1. Click on the Customize Quick Access Toolbar icon.
  2. Select ‘More Commands’.
  3. In the ‘Excel Options’ dialogue box, from the ‘Choose command from’ drop-down, select ‘All Commands’.
  4. Scroll down the list and click on ‘Select Visible Cells’ option.
  5. Click on the Add button.
  6. Click OK.

The above steps would add the ‘Select Visible Cells’ command to the QAT.

Quick Access Toolbar In Excel 2013 For Mac Osx

Now you when you select a dataset and click on this command in the QAT, it will select visible cells only.

Quick Access Tool Bar In Excell 2013 For Mac

You May Also Like the Following Excel Tutorials:

Quick Access Tool Bar In Excell 2013 For Mac Catalina

  • How to Hide a Worksheet in Excel (that can’t be unhidden).
  • How to Select Every Third Row in Excel (or select every Nth Row).
  • How to Quickly Select Blank Cells in Excel.

Quick Access Toolbar In Excel 2013 For Mac Shortcut

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster