Learn how to quickly combine text from two or more Excel cells using simple methods like the ampersand (&) operator and the CONCAT function. This guide shows you how to merge values, add spaces between text, and apply formulas across entire columns in seconds using the fill handle.
Continue readingEXCEL: Understand your data with super-fast charts & graphs
Learn how to create charts and graphs in Excel in seconds using simple shortcuts, the Quick Analysis tool, and the Insert tab. This guide shows you how to turn raw data into clear, professional visuals that make trends easier to understand and reports more impactful.
Continue readingEXCEL: Make dull data stand out and become dynamic
Learn how to transform ordinary spreadsheets into professional, dynamic Excel reports using built-in features like Excel Tables, Conditional Formatting, Slicers, and Dynamic Arrays. These simple techniques will help you create interactive dashboards that update automatically, improve data visualisation, and save time—without writing a single line of code.
Continue readingEXCEL: Do super-fast sums without formulas
Discover three quick ways to calculate totals in Excel without manually typing formulas. Learn how to use the AutoSum shortcut, Status Bar calculations, and Excel Tables to add up rows and columns in seconds. These simple time-saving techniques will help you work faster, reduce errors, and boost your Excel productivity
Continue readingEXCEL: Make a dropdown list to select from
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.