The presentation of an Excel document can be extremely important, especially if that document will be seen by business partners or clients. If you have a long list of numbers on your spreadsheet, but ...

In Microsoft Excel, turning Scroll Lock on allows you to use the arrow keys to navigate your business spreadsheet without moving the cell that you have selected. The current state of Scroll Lock is ...

Q. Thanks for your tip on teaching Excel to speak the numbers in a spreadsheet ( JofA , Dec.03, page 91). It really was keen. However, how do you turn the darn thing off? I keep clicking on the off ...

Messy Excel formulas are more than just an eyesore—they're harder to maintain. Every repeated cell reference and tangled ...

Learn how Excel functions can act as data using LAMBDA, LET, and BYROW, so you reuse logic and cut formula edits.

How to Control Data Conversions in Excel for Windows and Mac Your email has been sent After years of struggling with Microsoft Excel's internal conversion feature, users can now disable Excel's ...

Excel saves your previous formatting criteria, so to avoid confusion, you need to clear them. Click the down arrow next to the Find What field, and select "Clear Find Format." Then, click "Clear ...