Last week I wasted an entire afternoon because of an errant bug in my Excel that prohibited me from being able to use Excel’s Paste Special dialog. When I’d select Paste Special, I’d get this useless menu: After reinstalling Microsoft Office, I was dismayed to find out the bug was still there. Turns out the […]
Search Results for: excel
How To Create Internal Links in Excel
It’s safe to assume most people know how to create links in Excel that point to Web pages. Personally, I prefer to use the shortcut Ctr-K (Mac: Command-K), but you can also choose Hyperlink from the contextual menu. (Select the text or object and right-click it to get the contextual menu.) However, Excel also offers […]
Auto Increment Lists By Dragging In Excel
One nice option you have in Excel is the ability to drag series values down, saving you the time of entering individual values for well-known lists. Here are a few data types you can drag to auto increment: numbers years months day of week date time To take advantage of this shortcut, just add your […]