Keyboard Shortcuts: Excel — Business Management Daily: Free Reports on Human Resources, Employment Law, Office Management, Office Communication, Office Technology and Small Business Tax Business Management Daily
  • LinkedIn
  • YouTube
  • Twitter
  • Facebook
  • Google+

Keyboard Shortcuts: Excel

Get PDF file

by on
in Excel Training,Keyboard Shortcuts,Office Technology

Ctrl++ Use Ctrl++ (plus) to insert cells (if clicked on a column, inserts column; if clicked on a row, inserts row). Another way to express this shortcut is Ctrl+Shift+= . This keyboard shortcut combination may also work with the + on the 10-key pad. Select multiple columns or rows to insert multiples.

Ctrl+- Use Ctrl+- (minus) to delete cells (if clicked on a column, deletes column; if clicked on a row, deletes row). Also may work with the - on the 10-key pad. Select multiple columns or rows to delete more than one at a time.

Ctrl+! Use Ctrl+! to change the cell format to number. Another way to express this shortcut is Ctrl+Shift+1. By default it sets the decimal places to 2. While it will set the cell type to Number, if the cell contains text, it does not alter it.

Leave a Comment

Previous post:

Next post: