News

The Switch Row or Column feature allows you to swap data over the axis. Learn how to switch Rows and Columns in Microsoft Excel.
Want to to alternate row colors in Excel? You can apply color in alternate row & column in Excel spreadsheet using Conditional Formatting.
How do you freeze rows and columns in Google Sheets? Similar to Excel, Google’s own spreadsheet software has freeze-unfreeze options for you to mess around with.
How to Reconfigure a Horizontal Row to a Vertical Column in Excel. When you're configuring data in a Microsoft Excel worksheet, you may realize that the information you entered in rows makes ...
Freezing a row in Microsoft Excel or Google Sheets can organize your spreadsheet and make sorting through data a breeze. Here's how to do it.
You can freeze columns in Excel with a few clicks, and then unfreeze them when you no longer need to view them statically.
Excel’s BYCOL() and BYROW() functions evaluate data across columns and rows, returning an array result set allowing you to bypass a lot of work.
The larger a spreadsheet gets, the more likely you'll want to start hiding rows or columns or maybe you've been given a sheet that has hidden rows or columns.