When you link a cell in Excel to a cell from another worksheet, the cell that contains the link shows the same data as the cell from the other worksheet. The cell that contains the link is called a ...

Q. I have an Excel workbook with dozens of custom-named worksheets. Is it possible to create a list of those worksheet names in Excel without having to retype them? A. Yes, you can create a list of ...

Q. I’ve been trying to give descriptive names to spreadsheet cells—rather than use cell-location codes (A1, B2 and so forth)—and while sometimes it works, other ...

Excel puts lots of great tools on your desktop, but what each one of them does isn’t always obvious, especially since so many Excel features are hidden. Would you like to create multiple lines of text ...