If you often scroll through long Excel sheets, learning how to freeze the top 2 rows will make navigation far smoother. Excel’s Freeze Panes feature lets you lock multiple rows, columns, or both, so ...

People interpret data differently; some insert data horizontally and others prefer to do it vertically. For flexibility, Microsoft Excel comes with the Transpose feature, which lets you switch columns ...

In addition to storing typed data in each cell of a spreadsheet, Microsoft Excel allows you to perform functions on one cell and show the result in another cell. The most basic function, a link, ...

If you’ve ever worked with an enormous Excel spreadsheet, you’ll know just how daunting all those rows and columns can be. Once you’re over 10 or 15 different values and labels, it can get pretty ...

If you want to know how to hide cells in Excel, we’ve got you covered right here. Microsoft Excel is the go-to software for any companies or small businesses that need to keep track of their ...

Sometimes users don't want others to see information in an Excel spreadsheet, but why? Isn't that defeating the object of having a spreadsheet in the forest place? Well not exactly. Let's take a ...

Applying shading to alternative rows (zebra stripe rows) in Excel makes your sheet easier to read. The effect, also known as banded row, allows your eyes to keep their place more easily when you’re ...

We show you how to hide and unhide rows and columns in Excel using the mouse, hotkeys, the toolbar and how you can deal with hidden rows on the top of your table. The ability to hide and unhide rows ...

There are several tricks you can use to organize or otherwise clean up your spreadsheets across multiple apps, from automated calculations to setting up filters. In fact, it's often necessary (or at ...