How to hide rows in Google Sheets on on a computer or mobile device

You can easily hide rows in Google Sheets on your computer or mobile device. The same method can be used to unhide rows as ...

How to freeze a row in Excel so it always stays on the screen, even when you scroll away

You can freeze a row in Excel through the "Freeze Panes" menu. This lets you scroll through a spreadsheet without that frozen ...

This obscure Microsoft Excel tool imports PDF data without mangling it

In the top menu of Excel select Data > Get Data > From File > From PDF. Browse your files and select the PDF with the table ...
MUO on MSN

I stopped consolidating sheets by hand because Excel’s INDIRECT function does all the work for me

With the INDIRECT function, you can reference and consolidate key data points across sheets. It's a straightforward process ...