The end goal is to produce the same effect as the View > Freeze Panes > Freeze Top Row command in Excel 2007 so that the top row of the worksheet is frozen and users can see the top row of the worksheet even as they scroll through the data. How to lock cells in excel 2008 for mac freeze rows and columns. Excel for mac shortcuts tagged quot;excel shortcuts for mac quot; excel skin™. Microsoft excel taking the pain out of freezing panes accountingweb. How to lock cells in excel 2016. Excel fix cell in formula mac how to show formulas in excelms.
Photo credit: / Shutterstock.com Excel is one of the most used softwares for storing and manipulating tabular data. If you have arrived at this blog, I assume that you are an avid user of this software and are desperately in need of some Excel shortcuts to make your work easier. Excel Shortcuts: Next workbook or Previous workbook To open the next workbook, the shortcut is Ctrl + Tab for both Windows and Mac. To open the previous workbook, you should press Ctrl + Shift + Tab. Excel Shortcuts: Next worksheet or Previous worksheet Many times we need to switch between various worksheets in the same workbook. The shortcut for doing this task comes in handy and makes work much simpler! Shortcut to move to the next sheet to the right: For Windows: Ctrl + PgDn For Mac: Fn + Ctrl + Down arrow Shortcut to move to the next sheet to the left: For Windows: Ctrl + PgUp For Mac: Fn + Ctrl + Up arrow Excel Shortcuts: Select All The shortcut for the “select all” functionality is Ctrl + A.
However this shortcut behaves differently in different contexts in Excel. In the event that the cursor is in a void cell, Ctrl + A chooses the whole worksheet. In any case, if the cursor is in a gathering of bordering cells, Ctrl + A will choose the whole gathering of cells. This behaviour of Ctrl + A is different when the cursor is in a table. When you use Ctrl + A for the first time, only the table data is selected.
If you use Ctrl + A again, then the table header is also selected along with the table data. On using Ctrl + A continuously for the third time, the entire excel worksheet will be selected. Excel Shortcuts: Go to the first cell in current worksheet Exploring bigger worksheets can get truly monotonous. Indeed, you can utilize the scroll bars to look over the worksheet, yet using the scroll bars requires lots of patience. If you want to reach the very first cell, that is the A1 cell of the current worksheet, use the following shortcut: For Windows: Ctrl + Home For Mac: Fn + Ctrl + Left arrow Using this shortcut will bring you to the A1 cell right away, irrespective of your current position in the worksheet! Excel Shortcuts: Go to the last cell in current worksheet The first question that might arise in your mind is — what is the last cell in a worksheet?
The last cell in a worksheet is at the crossing point of the last column that contains information and the last row that contains information. Many times it may happen that the last cell of the worksheet does not really have any data in it.
Shortcut to go to the last cell of the worksheet: For Windows: Ctrl + End For Mac: Fn + Ctrl + Right arrow One of the uses of this shortcut is to quickly verify if there exists any data in the sheet that you do not know about. It may happen that there is some stray data in a very far away cell in the worksheet. This shortcut comes to rescue and helps you check that. After all, if you want to print your data in the worksheet, you would not want to print 20 blank pages just to find some stray data in some far away cell! Excel Shortcuts: Selecting a row or a column in the current worksheet Selecting a row or a column is one of the most common tasks in Excel. Fortunately, there are shortcuts for that too! Excel shortcut to select a row: Shift + Space Excel shortcut to select a column: Ctrl + Space Once you select the desired row or column, you can broaden your selection by holding the shift key along with the appropriate arrow key.
Excel Shortcuts: Expanding or collapsing ribbon You can collapse the ribbon when you don’t need it and bring it back as and when desired by using the following shortcuts. Shortcut for Windows: Ctrl + F1 Shortcut for Mac: Command + Option + R Excel Shortcuts: Adding non-adjacent cells in a selection Many of the frequent tasks that we do on Excel involve selecting non-adjacent cells. You might want to enter the same data in the selected non-adjacent cells, delete their data, etc. Non-adjacent cells can be easily selected by using Ctrl + Click in Windows and Command + Click in Mac. You need to select the first cell and then hold the Ctrl or Command key while you click on other cells that you want to include in our selection. Excel Shortcuts: Selecting till the edge of the data Exploring big tables (say, containing 15,000 rows) at high speed is fun, but you will need to select large groups of cells for doing this.
Since you will attempt to do this manually, you will surely take a long time. Really, a very long time. To avoid scrolling and yet selecting till the edge of the data, you can use the following shortcuts: Shortcut for Right selection: Shift + Ctrl + Right arrow Shortcut for Left selection: Shift + Ctrl + Left arrow Shortcut for Upward selection: Shift + Ctrl + Up arrow Shortcut for Downward selection: Shift + Ctrl + Down arrow Even though the cursor moves quickly, don’t worry, the selection will be accurate. Excel Shortcuts: Finding next match Finding a piece of text is one of the most common activities done on any software that deals with data. To use the Find feature of Excel, you can use the following shortcuts: For Windows: Ctrl + F For Mac: Command + F Once you have found at least one match, you can keep searching for subsequent matches by using Shift + F4 on Windows and Command + G on Mac.
Excel Shortcuts: Showing the active cell on current worksheet It happens many times that our cursor gets lost and is nowhere in sight. In such a situation, to bring the cursor back in view, you can use Ctrl + Backspace on Windows and Command + Delete on Mac. You will find the cursor nicely centered in the worksheet. Excel Shortcuts: Adding a new line inside the current cell The following shortcuts will help you enter new lines inside the current cell: For Windows: Alt + Enter For Mac: Control + Option + Return Excel Shortcuts: Inserting current date or current time Shortcuts for entering current date or current time can come handy frequently. Following shortcuts will help you do these tasks conveniently. Shortcut to enter current date: Control +; Shortcut to enter current time: Control + Shift +: Excel Shortcuts: Bold, Italic, Underline Formatting text to make it look bold, italic, or underlined is one of the most frequently done tasks in Excel. After all, the important text should stand out from the normal text to highlight its importance!
Shortcut for “Bold” in Windows: Ctrl + B Shortcut for “Bold” in Mac: Command + B Shortcut for “Italic” in Windows: Ctrl + I Shortcut for “Italic” in Mac: Command + I Shortcut for “Underline” in Windows: Ctrl + U Shortcut for “Underline” in Mac: Command + U Excel Shortcuts: Insert rows or columns in a table For inserting a row or a column using an excel shortcut, you first need to select an entire row or column. Using the shortcut Ctrl + Shift + + in Windows (and Control + I in Mac) will add a new row adjacent to the selected row, or add a new column to the right of the selected column. You can also insert multiple rows or columns using the same shortcut. For doing that, you need to select the number of rows or columns equal to the number of new rows or new columns you want to insert.
Excel Shortcuts: Delete rows or columns in a table To delete a single row or column, select it and use the shortcut Control + – (works for both Windows and Mac). You can also delete multiple rows or columns using the same shortcut after selecting them all. The above mentioned shortcuts will come very handy when you work with Excel.
I hope you found them useful and will be using them often. Enjoy easy-working with!