#How to unhide row in excel for mac 2016 how to#
#How to unhide row in excel for mac 2016 Pc#

#How to unhide row in excel for mac 2016 Pc#

Thanks for reading CFIвЂ™s guide to Excel shortcuts for your PC and Mac keyboard! By taking the time to learn and master these keys, youвЂ™ll significantly speed up your financial analysis.

#How to unhide row in excel for mac 2016 how to#

If you want to learn these keyboard shortcuts with your own personal online instructor, check out CFIвЂ™s Free Excel Crash Course! YouвЂ™ll receive step by stepВ instructions and demonstrations on how to avoid the mouse and only use your keyboard. Excel is quite robust, meaning there are a lot of different tools that can be utilized within it, and therefore there are many skills one can practice and hone. You may also want to check out our section on Excel formulas or the Excel formulas cheat sheet. If you follow our tips and tricks below youвЂ™ll be able to master these shortcuts on Windows or Mac operating systems. Your mouse will be taken away and youвЂ™ll be expected to learn financial modeling with only keyboard shortcuts. The first thing youвЂ™ll do if youвЂ™re hired as an investment banking analyst is take a series of intense Excel training courses. Row 1 should now be visible in the spreadsheet. Select Cells > Format > Hide & Unhide > Unhide Rows.

Select the Home tab from the toolbar at the top of the screen. However, when you unhide the rows or columns, they will automatically show up in the chart. You can also do this by hiding the rows or columns in your worksheet. Press COMMAND and select the other rows and columns you want. Clicking this cell will select all cells in your spreadsheet, both hidden and not. Set row height to 15 in the resulting dialog and click OK. Position your cursor in the first row or column. First, click the top-left heading cell that looks like a white arrow pointing to the bottom-right corner. When the GoTo window appears, enter A1 in the Reference field and click on the OK button. At the top left of Excel is the Name box, type A1:A12 into that box and hit Enter (important) Then, on the Home Ribbon, click Format - Row Height. These are critical for careers in investment banking, equity research, FP&A, finance, accounting, and more. In the Editing group, click on Find & Select button and select 'Go To.' from the popup menu. Then right-click on row 387 and select 'Unhide'. You can also select row 387 and drag your mouse up slowly until you see a pop-up that tells you that you have selected 387 Rows (see the '21R' pop-up in the image below).

To be more productive, faster, and more efficient when building financial models or performing financial analysis, itвЂ™s important to know the main keyboard shortcuts in Excel. After clicking on the Select All button, you can right-click on one of the row numbers and select 'Unhide'.