Using a mouse in Excel, like hard coding formulas, is a dead giveaway that you’re new to Excel. When you open a new workbook, or when you add new worksheets to an existing workbook, Excel uses a generic name for Using Excel for the first time can be overwhelming, but just know that you can take it one cell at a time! Whether you’re using Excel for the first time, or you’re a novice and you want to improve, keyboard shortcuts are something you’re going to want to know. Well also look at how to change the color of worksheet tabs. Depending on your template needs, you also have the ability in the Options Dialog to modify your worksheet further, including removing scrollbars and row and column headers.In this lesson, well look at how to name and rename worksheets. The option is available from the Main Menu under Tools->Options and by selecting the View tab. If your template design requires making Excel look less like Excel, you might want to turn off sheet tabs.
![]() Show Worksheet Tabs In Excel How To Change TheCtrl + spacebar to select the whole column Ctrl to shift + end or Ctrl + shift + fn + right arrow to extend the selection to the last cell used on the sheet (lower-right corner) Ctrl + shift + home or Ctrl + shift+ fn+ left arrow to extend the selection to the beginning of the sheet Shift + home or Shift + Fn + left arrow to extend the selection to the beginning of the row Command + shift + j to ungroup selected cells Command + shift + k to group selected cells Ctrl/ command + 1 to edit cells (outlines, color, type, etc.) which allows you to edit… F2 to make a cell active (can also double click or edit in the formula space up top) Ctrl/ command + enter to fill the selected cell range with the current entry Ctrl/ command + D to fill down (highlight cells first) Ctrl/ command + 0 to hide selected columns Ctrl/ command + 9 to hide selected cells Powerpoint addin for camtasia for macCtrl + grave accent (‘) alternates between displaying cell values and cell formulas Ctrl/ command + shift + < to decrease font size Ctrl/ command + shift + > to increase font size Review (to protect and share your workbook)- Alt + R Data (to sort, filter, do data validation, etc.)- Alt + A Formulas (to insert and customize functions)- Alt + M Page layout (to change size, orientation, margins, etc.)- Alt + P Insert (to insert pivot tables, images, charts, etc.)- Alt + N This shows the number of females vs. Here, I have day under filters, region under columns, gender under rows, and values as count. To analyze relationships between different factors, pivot tables are extremely useful! To insert one, first press Alt then N to get to the Insert Tab.A dialog box will pop up where you can enter your data range (note you can have the pivot table pop up in a new worksheet or existing one).Manipulate your pivot table by dragging different variables into the filters, columns, rows, and values boxes.
0 Comments
Leave a Reply. |
AuthorRobert ArchivesCategories |