Excel Basics - Wall Street Prep

Excel Basics - Wall Street Prep
Create new sheet - ans>>ctrl i w
switch between sheets - ans>>ctrl page up / ctrl page down
access anything on the ribbon - ans>>atl
toggle between excel books - ans>>ctrl tab
open new file - ans>>ctrl o
bold - ans>>ctrl b
options - ans>>alt f t
auto size cell - ans>>alt h o i
designate width of box - ans>>alt h o w
highlight column - ans>>ctrl space
highlight row - ans>>shift space
undo - ans>>ctrl z
redo - ans>>ctrl y
formatting - ans>>ctrl 1
highlight all columns next - ans>>ctrl shift > / <
paste special - ans>>alt e s
zoom in / out - ans>>alt v z
freeze pane - ans>>alt w f f
To keep selected rows and/or columns of the worksheet visible on the screen as the rest of the worksheet scrolls.
split pane - ans>>alt w s
hop between panes - ans>>F6
go inside cell to see functions - ans>>F2
go inside cell to clear specific info - ans>>ALT h e
input comment - ans>>Shift F2
Fill Highlighted Area Right / Down - ans>>ctrl r / ctrl d
Input New Row - ans>>ALT i r
input new column - ans>>alt i c
deleting columns / rows - ans>>ALT H D R / ALT H D C
Paste Special Formatting - ans>>ALT E S T
Trace Precedents - ans>>ATL M P / (delete it ALT M A A) allows you to see which cells are referenced in a particular formula or
function