Switching a cell reference from relative to absolute is ideal when you don’t want it shifting in a formula after you copy and paste elsewhere or use the fill handle to populate adjacent cells. Using A2 as an example, you…
Quick gripe to start the morning with: pillows. It doesn’t seem to matter whether I’m in a budget Travelodge or an expensive hotel in West London — the pillows are never up to standard. At home, I have a memory…
Excel has options allowing you to restrict cell entry so data is kept accurate and consistent. The Data Validation button is found on the Data tab. Selecting it brings up a window letting you limit the active cell or range…
In a new Excel worksheet, I enter this formula in A1: After waiting 12 seconds, a spilled sequence is generated from 1 in A1 to 53673984 in XFD3276. XFD is indeed the 16384th column of a worksheet — the very…
English is an ever-evolving language, with most dictionaries welcoming 500–1,500 new words every year. The job of a lexicographer is to compile dictionaries, adding and editing entries as they monitor what and how words are used in everyday life. Lexicographers…
Excel has limits — plenty of them. Whether it’s the number of worksheet rows, characters in a cell, or the percentage you can zoom in. We’ve all bumped into a limit of some type at some point. There’s a useful…
End of content
End of content
