Don’t waste valuable time typing the same data into Excel repeatedly. We show you how to create a dropdown list to save time!
Continue readingEXCEL: Insert live Excel data into Word
Need to display data from an Excel sheet in your Microsoft Word document? We show you how including live link.
Continue readingEXCEL: Swap rows into columns and vice versa
Need to swap rows into columns and vice versa in Excel? We’ll show you how to use the Transpose function…
Continue readingEXCEL: Create ranges of data without doing any typing
Manually typing long lists of numbers, dates, or repeating text patterns in Excel? We show you how to use the AutoFill function to save you time!
Continue readingEXCEL: Instantly see all data in columns & rows
Do you need to adjust the column width in Excel to see the data? We show you how to use the Auto-Fit function to save time!
Continue readingEXCEL: Always see the headings on scrolling
Excel is great for looking at lots of data, but when you can’t see the column or row headers, you have to scroll back and forth to check what the data means. Did you know there’s a great time saver which can lock the headers in place? Here’s how to do it.
Working with large spreadsheets? Excel’s Freeze Pane feature makes it easy to keep your headers visible as you scroll, so you never lose track of your data.
How to Freeze Headers
- Select the cell: Click the cell directly below the rows and to the right of the columns you want to lock.
- Tip: To freeze just the top row, click any cell in Row 2.
- Go to the View tab: Find it in the top ribbon.
- Freeze Panes: Click Freeze Panes and select Freeze Panes from the dropdown.
Quick Alternatives
- Freeze Top Row: Locks the very first row instantly.
- Freeze First Column: Locks the leftmost column instantly.
To unlock, simply go to View > Freeze Panes > Unfreeze Panes.
We regularly update the Tech Tips with new articles and advice from the IT West team so be sure to check back for the latest technical tips, tricks and guidance from our team of business IT experts.