Day 6 – Spreadsheet Survival Skills

– Freezing rows/columns: select the row/columns below/behind which you want implement the freeze. Then go to Windows -> Freeze

– Copying the same formula over various cells (relative reference): click on the right hand corner of the cell with formula and drag down to cover the cells where the formula is wanted. If you put a dollar sign in the middle of the two letters that make up the row/column, you get an absolute reference (where all the copied down formula pointed to the same cell).

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s