Forum Discussion

Brass Contributor

Aug 10, 2020

Solved

Column width

I would like to know if I can use a formula to set a column width that depends on the width of the row number. For example: If the row number exceeds 999, then the row number column width increases i...

excel

Formulas and Functions

amit_bhola
Aug 23, 2020
tomc72 , as workaround, you can hide the headings by going to VIEW tab and unchecking the Headings under "Show" as shown in below image. Then on scrolling down, the columns won't shift to the right. But compromise is, you cannot see row numbers (1,2,3...)or column headers (A,B,C...).

silverfox251

Copper Contributor

Aug 22, 2020

I have a checkbook register in Excel. What I would like to do is to format the date column, so when I enter a date it will appear in the correct order. For example, 7/10/20 will appear after 7/5/20 but before 8/10/20.

tomc72
Brass Contributor
Aug 22, 2020
silverfox251
as per Amit
Thank you
amit_bhola
Iron Contributor
Aug 22, 2020
silverfox251 , hi, yours is a new problem, so it is suggested to start a new discussion thread for the same.
Go to Start a New Conversation as shown in image below. Also it is suggested to attach your example excel file when you post the problem. BTW, it looks like you just have to sort the register table by date, still people here would be better able to understand your issue if you attach your file (delete any confidential info of yours before uploading here)