September 17, 2021
I now have 12 nearly identical worksheets. I have to make a similar change to all 12 sheets.
September 16, 2021
I’ve created the perfect report for January. I’ve formatted the column widths. I’ve changed the Page Setup. I have custom views. I need to make copies of the report for February through December in the current workbook.
September 15, 2021
I want to move row 5 to appear after row 7. I don’t want to sort. I don’t want to insert a new row, copy, paste, delete the old row. What is the fastest way?
September 14, 2021
I have a column that contains 20 department names going down a column. I need to build a worksheet with those names going across row 1.
September 13, 2021
I have a range of formulas that I need to convert to values.
September 10, 2021
I need to copy from Excel to Outlook. Microsoft applies weird formatting to the values when I paste to Outlook. Instead of getting just the text, it almost seems like Outlook is wrapping the cell value in a table. I end up pasting Excel data to Notepad, then copying from Notepad.
September 9, 2021
I have a worksheet with thousands of rows of data. I often enter a formula in a new column and need to copy it down to all of the rows. I try to do this by dragging the fill handle. But as I try to drag, Excel starts accelerating faster and faster. Before I know it, I’ve overshot the last row by thousands of rows. I start dragging back up. Again, Excel starts accelerating. Soon, the cell pointer is moving somewhere close to the speed of sound, and I find that I’ve overshoot the last row in the other direction. I end up going down and up, down and up. I call this frustrating process the “fill handle dance.” Is there a way to stop the madness?
September 6, 2021
I have a large column of numbers stored as text. I like to use the error correction dropdown that appears next to the first cell in the selection in order to convert the text to numbers. However, if I choose the first cell, then select the range with Ctrl+Shift+Down Arrow, I can no longer see the error dropdown.
September 2, 2021
I have thousands of rows of data. I want to quickly move to the edge of the data using my mouse.