Create new sheet correct answers ctrl i w
switch between sheets correct answers ctrl page up / ctrl page down
access anything on the ribbon correct answers atl
toggle between excel books correct answers ctrl tab
open new file correct answers ctrl o
bold correct answers ctrl b
options correct answers alt f t
auto size cell correct answers alt h o i
designate width of box correct answers alt h o w
highlight column correct answers ctrl space
highlight row correct answers shift space
undo correct answers ctrl z
redo correct answers ctrl y
, formatting correct answers ctrl 1
highlight all columns next correct answers ctrl shift > / <
paste special correct answers alt e s
zoom in / out correct answers alt v z
freeze pane correct answers 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 correct answers alt w s
hop between panes correct answers F6
go inside cell to see functions correct answers F2
go inside cell to clear specific info correct answers ALT h e
input comment correct answers Shift F2
Fill Highlighted Area Right / Down correct answers ctrl r / ctrl d
Input New Row correct answers ALT i r