excel mac key shortcut to go to specific row number

Enter the name you want to give to the selection in the Name Box (no spaces allowed in the name).Select the columns for which you want to create the named range (hold the Control key and then select the columns one-by-one).Once created, you can simply enter the named range name in the Name box (or select it from the drop-down)īelow are the steps to create a named range for specific columns:

Instead of doing it one by one or entering it manually in the Name Box, here is what you can do – create a named range that refers to the columns you want to select.

Suppose you’re working in a workbook where you may often have a need to select far-off columns (say column B, D, and G). Let me also show you another wonderful trick. It allowed me to quickly select columns and format them at once, or delete/hide these columns in one go. When I used to work as a financial analyst years ago, I found this trick extremely useful. If you want to select multiple columns that are not adjacent, say D, H, and I, you can enter the below: D:D,H:H,I:I Right-click anywhere in this new selection and select Hide. Select the first column you don’t need to see and then press the keyboard shortcut CTRL+SHIFT+right arrow (for Mac use Command+Shift+right arrow). Similarly, if you want to select multiple columns (say D, E, and F), enter the following in the name box: D:F Hide the selected rows/columns: you can hide the selected row using Ctrl+9 and Ctrl+0. While the main purpose of the Name Box is to quickly name a cell or range of cells, you can also use it to quickly select any column (or row).įor example, if you want to select the entire column D, enter the following in the name box and hit enter: D:D

Excel mac key shortcut to go to specific row number