Custom fit rows alt h o h - Study guides, Class notes & Summaries

Wall Street Prep Excel -Exam Questions With 100% Correct Answers Add/delete sheets - answeralt-i-w OR alt h-i-s Moving around task ribbon - answerTab and shift (to select) Auto fit cell - answeralt-h-o-i Custom fit columns - answeralt h-o-w Custom fit rows - answeralt h-o-h Select entire column/row - answerctrl shift-arrow key Format cells - answerctrl 1 Paste special - answeralt e-s Freeze panes - answeralt w-f-f Split panes - answeralt w-s Move between panes - answerF6 Get in cell...

Wall Street Prep: Excel 100% Verified Add/delete sheets alt-i-w OR alt h-i-s Moving around task ribbon Tab and shift (to select) Auto fit cell alt-h-o-i Custom fit columns alt h-o-w Custom fit rows alt h-o-h Select entire column/row ctrl shift-arrow key Format cells ctrl 1 Paste special alt e-s Freeze panes alt w-f-f Split panes alt w-s Move between panes F6 Get in cell AND navigate to others while inside F2 Edit a cell from the outside alt h-e Add comments Shift F2 Right (and down...

Add/delete sheets - Answer-alt-i-w OR alt h-i-s Moving around task ribbon - Answer-Tab and shift (to select) Auto fit cell - Answer-alt-h-o-i Custom fit columns - Answer-alt h-o-w Custom fit rows - Answer-alt h-o-h Select entire column/row - Answer-ctrl shift-arrow key Format cells - Answer-ctrl 1 Paste special - Answer-alt e-s Freeze panes - Answer-alt w-f-f Split panes - Answer-alt w-s Move between panes - Answer-F6 Get in cell AND navigate to others while insi...

Add/delete sheets - alt-i-w OR alt h-i-s Moving around task ribbon - Tab and shift (to select) Auto fit cell - alt-h-o-i Custom fit columns - alt h-o-w Custom fit rows - alt h-o-h Select entire column/row - ctrl shift-arrow key Format cells - ctrl 1 Paste special - alt e-s Freeze panes - alt w-f-f Split panes - alt w-s Move between panes - F6 Get in cell AND navigate to others while inside - F2 Edit a cell from the outside -...

Wall Street Prep Excel Exam Questions with Correct Answers Add/delete sheets - ANSWER alt-i-w OR alt h-i-s Moving around task ribbon - ANSWER Tab and shift (to select) Auto fit cell - ANSWER alt-h-o-i Custom fit columns - ANSWER alt h-o-w Custom fit rows - ANSWER alt h-o-h Select entire column/row - ANSWER ctrl shift-arrow key Format cells - ANSWER ctrl 1 Paste special - ANSWER alt e-s Freeze panes - ANSWER ...

Add/delete sheets - alt-i-w OR alt h-i-s Moving around task ribbon - Tab and shift (to select) Auto fit cell - alt-h-o-i Custom fit columns - alt h-o-w Custom fit rows - alt h-o-h Select entire column/row - ctrl shift-arrow key Format cells - ctrl 1 Paste special - alt e-s Freeze panes - alt w-f-f Split panes - alt w-s Move between panes - F6 Get in cell AND navigate to others while inside - F2 Edit a cell from the outside - alt h-e

Add/delete sheets - alt-i-w OR alt h-i-s Moving around task ribbon - Tab and shift (to select) Auto fit cell - alt-h-o-i Custom fit columns - alt h-o-w Custom fit rows - alt h-o-h Select entire column/row - ctrl shift-arrow key Format cells - ctrl 1 Paste special - alt e-s Freeze panes - alt w-f-f Split panes - alt w-s Move between panes - F6 Get in cell AND navigate to others while inside - F2 Edit a cell from the outside - alt h-e

Add/delete sheets - alt-i-w OR alt h-i-s Moving around task ribbon - Tab and shift (to select) Auto fit cell - alt-h-o-i Custom fit columns - alt h-o-w Custom fit rows - alt h-o-h Select entire column/row - ctrl shift-arrow key Format cells - ctrl 1 Paste special - alt e-s Freeze panes - alt w-f-f Split panes - alt w-s Move between panes - F6 Get in cell AND navigate to others while inside - F2 Edit a cell from the outside -...

Add/delete sheets Correct Answer alt-i-w OR alt h-i-s Moving around task ribbon Correct Answer Tab and shift (to select) Auto fit cell Correct Answer alt-h-o-i Custom fit columns Correct Answer alt h-o-w Custom fit rows Correct Answer alt h-o-h Select entire column/row Correct Answer ctrl shift-arrow key Format cells Correct Answer ctrl 1 Paste special Correct Answer alt e-s Freeze panes Correct Answer alt w-f-f Split panes Correct Answer alt w-s Move between panes ...

Wall Street Prep Excel Crash Course Exam 246 Questions with Verified Answers Keyboard Versus the Mouse - CORRECT ANSWER Almost everything that can be done in Excel using a mouse can also be done using the keyboard shortcuts Best way to learn is to disconnect the mouse and work through Excel using only the keyboard Name Box - CORRECT ANSWER Tells you what cell you are in (top left below the ribbon) Formula Bar - CORRECT ANSWER When you insert a formula into a cell and hit return, the ce...