Excel Tips
Copy Column Widths to a New Range »
September 25, 2023
I have a small report in columns A:G. I made a copy of that report in column H. The column widths did not get copied over. It is a pain to individually look at each column width in A through G and then make the same column width in the new report.
Change the Width of All Columns with One Command »
September 22, 2023
I have a large model set up in Excel. Some of the columns are hidden. I want to globally change the width of all unhidden columns to a width of 4. If I choose all columns in the worksheet and use Home, Format dropdown, Column Width, the hidden columns will unhide.
Move Rows or Columns with Shift Drag »
September 20, 2023
I need to rearrange some rows or columns. Do you have anything faster than the other methods you’ve described?
Move Columns Using Insert Cut Cells »
September 19, 2023
I need to rearrange two columns. The left-to-right sort trick described in “Move Columns by Sorting Left to Right” seems overly complex.
Move Columns by Sorting Left to Right »
September 18, 2023
My IT department produces a report every day, and the columns are in the wrong sequence. It would take them two minutes to rewrite the query, but they have a six-month backlog and don’t have time to get around to it. How can I rearrange the columns?
Share Styles Between Workbooks »
September 15, 2023
I created the CommaGood style as discussed in the last topic. But, it is only in the workbook that I used. Do I really have to do this for every single workbook?
September 14, 2023
Most of my worksheets deal with positive numbers. Thus, I prefer to use a number format of “#,##0” instead of the accounting format. When I use the Comma style, Excel uses the accounting format. This format allows for the possibility of negative numbers in parentheses, and therefore all the positive numbers are not quite right-aligned with the cell as shown here.
Use Cell Styles to Change Formats »
September 13, 2023
Gurus of Microsoft Word have known about using styles for two decades. Microsoft promotes styles in Excel, adding a dropdown right on the Home tab offering 42 built-in styles.
September 12, 2023
In my copy of Excel, I type 152 and Excel enters 1.52. What is going on?