## Series of dates by weekends

Example Related FunctionsWEEKDAY IF =IF(WEEKDAY(date)=7,date+1,date+(7-WEEKDAY(date)))If need to generate a dynamic series of dates with a formula that ...

## Series of dates by month

Example Related FunctionsDATE DAY EOMONTH MONTH YEAR =DATE(YEAR(date),MONTH(date)+1,DAY(date))If you need to generate a dynamic series of dates with a ...

## Series of dates by day

Example =date+1If you need to generate a dynamic series of dates with a formula that increase by one day from a single start date, you can do so a very ...

## Self-contained VLOOKUP

Example Related FunctionsVLOOKUP =VLOOKUP(lookup,{table_array},column,match)To make a self-contained VLOOKUP formula, you can convert the table array to ...

## Select visible cells only

Windows shortcut  Alt; Mac shortcut  ⌘⇧Z This shortcut will select only visible cells in the current selection. This means that cells in the ...

## Select to end of cell

Windows shortcut  ShiftEnd Mac shortcut  Fn⇧→ Inside a cell, this shortcut will select from the cursor to the end of the text. 0 votes. 0 / ...

## Select to beginning of cell

Windows shortcut  ShiftHome Mac shortcut  Fn⇧← Inside a cell, this shortcut will select from the cursor to the beginning of the text. 0 ...

## Select table

Windows shortcut  CtrlA Mac shortcut  ⌘A This shortcut selects the data area of a table, when the cursor is in an Excel table. Behavior changes as ...

## Select table row

Windows shortcut  ShiftSpace Mac shortcut  ⇧Space This shortcut selects one or more table rows in a table, when the cursor is in an Excel table. ...

## Select table column

Windows shortcut  CtrlSpace Mac shortcut  ⌃Space This shortcut selects one or more table columns in a table, when the cursor is in an Excel table. ...