Switch between hiding objects, displaying objects and displaying placeholders in Excel
In Microsoft Excel, press Ctrl+6 on Mac, Windows.
EscF1F2F3F4F5F6F7F8F9F10F11F12PrtScScrLkPause
`1234567890-=deleteInsHomePgUp
TabQWERTYUIOP[]\DelEndPgDn
CapsASDFGHJKL;'return
ShiftZXCVBNM,./Shift↑
fnctrloptcmdcmdopt←↓→
EscF1F2F3F4F5F6F7F8F9F10F11F12PrtScScrLkPause
`1234567890-=BkspInsHomePgUp
TabQWERTYUIOP[]\DelEndPgDn
CapsASDFGHJKL;'Enter
ShiftZXCVBNM,./Shift↑
CtrlWinAltAltWinMenuCtrl←↓→
See it happen Press the shortcut above, or
More Excel shortcuts: format cells
| Action | Mac | Windows |
|---|---|---|
| Open the Format Cells dialog | Cmd1 | Ctrl1 |
| Apply the General number format | CtrlShift` | CtrlShift` |
| Apply the Currency format with two decimal places | CtrlShift4 | CtrlShift4 |
| Apply the Percentage format with no decimal places | CtrlShift5 | CtrlShift5 |
| Apply the Scientific number format with two decimal places | CtrlShift6 | CtrlShift6 |
| Apply the Date format with day, month and year | CtrlShift3 | CtrlShift3 |
| Apply the Time format with hour, minute and AM or PM | CtrlShift2 | CtrlShift2 |
| Apply the Number format with two decimal places, thousands separator and minus sign | CtrlShift1 | CtrlShift1 |
| Apply an outline border to the selected cells | OptionCmd0 | CtrlShift7 |
| Remove the outline border from the selected cells | OptionCmd- | CtrlShift- |