Data literacy · Excel · ICT proficiency · Microsoft Office · Top tip · Working with Data

#33 Forgetting where you are in Excel? Freeze it!

When you are working with large spreadsheets, keeping track of which column or row you are working in can get a bit tricky. This is where the freeze function is really useful.

You can freeze your top row of headers or the first column separately, or you can combine with a number of different columns and rows frozen. These columns and rows then remain visible, no matter where in the spreadsheet you are working.

Take a look!

Featured Image: “Frozen waterfall, Japanese Alps” by Chi Tranter licenced under CC BY 2.0

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