Shortcut keys for mac cheat sheet
- #Shortcut keys for mac cheat sheet pdf#
- #Shortcut keys for mac cheat sheet Pc#
- #Shortcut keys for mac cheat sheet windows#
View (to preview page layout, line breaks, etc.)- Alt + WĮxample: creating a Pivot Table (Alt + N + V).Review (to protect and share your workbook)- Alt + R.Data (to sort, filter, do data validation, etc.)- Alt + A.Formulas (to insert and customize functions)- Alt + M.Page layout (to change size, orientation, margins, etc.)- Alt + P.Insert (to insert pivot tables, images, charts, etc.)- Alt + N.
#Shortcut keys for mac cheat sheet Pc#
* Pressing alt for a Pc opens up the ribbon at the top of excel which you can use to navigate between tabs* A cell formula is = 4+5 and a cell value is 9 (it’s useful to alternate when you have more complicated formulas and you want to edit specific parts) Ctrl + grave accent (‘) alternates between displaying cell values and cell formulas.Ctrl/ command + shift + Ctrl/ command + shift + > to increase font size.Number- how the number is formatted (the default is general).Ctrl/ command + 1 to edit cells (outlines, color, type, etc.) which allows you to edit….F2 to make a cell active (can also double click or edit in the formula space up top).Ctrl/ command + enter to fill the selected cell range with the current entry.Ctrl/ command + D to fill down (highlight cells first).Ctrl/ command + 0 to hide selected columns.Ctrl/ command + 9 to hide selected cells.Shift + spacebar to select the whole row.Ctrl + spacebar to select the whole column.Ctrl to shift + end or Ctrl + shift + fn + right arrow to extend the selection to the last cell used on the sheet (lower-right corner).Ctrl + shift + home or Ctrl + shift+ fn+ left arrow to extend the selection to the beginning of the sheet.
*shortcuts in bold pertain to Mac commands, and those in teal pertain to both* Navigating Workbook– the Excel spreadsheet file that houses all the data you have entered.Worksheet– aka a spreadsheet, there can be multiple in a workbook (tabs at the bottom indicate how many worksheets you have).Formula– a sequence inside of a cell that is used to produce a value, it must start with an equal (=) sign.Cell range– a collection of cells that have been identified as a group e.g.
#Shortcut keys for mac cheat sheet windows#
Have a Mac?īecause of the weird relationship Apple has with the Function keys on their keyboards, I’m not sure how many Mac users LIVE on their keyboards like Windows users do.
#Shortcut keys for mac cheat sheet pdf#
Maybe I’ll turn this into a sticker or something more tangible (click here for a PDF version)….Īlso, I talk about shortcuts in general here. But, you already know your favorites, yes? I know, I know, I forgot your FAVORITE ONE.
Or at least that’s what I’ve always called these. Oh well.Īnyways, we have lots of keyboard shortcuts in SQL Developer and a few in SQLcl. No? You probably also don’t remember a world sans e-mail and smart phones either. Remember back when Corel first released WordPerfect? Remember how it had like a bazillion keyboard shortcuts, and you needed help remembering them all?