#STUDENT COMMANDS 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 + < to decrease font size.

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.Shift + home or Shift + Fn + left arrow to extend the selection to the beginning of the row.

Command + shift + j to ungroup selected cells.

Command + shift + k to group selected cells.

Ctrl + page down/up or Option + right/left arrowВ to go between sheets.

Ctrl/ command + end to get to the end of a worksheet.

Ctrl + home or Ctrl + Fn + left arrow to move to the beginning of a sheet.

Ctrl/ command + arrow to get to the edge of a data set.

Arrow to navigate left, right, up and down.

*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.

Cell referenceвЂ“ a set of coordinates that identifies a specific cell e.g.

for whatever you want to do (a cell is вЂњactiveвЂќ when it is being edited)

CellвЂ“ a rectangle/block housed in a worksheet, any data is put in here and cells can display text, numbers, formulas, etc.

Just start here with this cheat sheet and one day youвЂ™ll be using ExcelвЂ¦.wait for itвЂ¦MOUSE-LESS! #goals Terminology to Know It works fine, but if you want to step it up, itвЂ™s good to learn keyboard shortcuts (itвЂ™s faster and looks good to employers!). Using a mouse in Excel, like hard coding formulas, is a dead giveaway that youвЂ™re new to Excel. Using Excel for the first time can be overwhelming, but just know that you can take it one cell at a time! Whether youвЂ™re using Excel for the first time, or youвЂ™re a novice and you want to improve, keyboard shortcuts are something youвЂ™re going to want to know.

Student commands for mac cheat sheet