Excel 2007 - Adjust column width automatically. Remove multiple log in details?

Jo4

Can anyone inform me how I can set up a 2007 Excel spreadsheet so it automatically adjusts the width of the column if the text entered is wider than the column is currently displayed?

Also, how do you remove log in details for a website? The computer has saved a few people's details so anyone using the computer could log into any account, some of which are no longer active.

Owain_Moneysaver

1. Select the column, go to Format - Column - Adjust to Fit or Auto Fit, something like that. This page should show how, but I can't see it.

2. Delete cookies, form data and passwords in your browser. For IE see here.

rmg1

AFAIK, unless you use code (i.e. VBA), you'd have to adjust the column width every time it was necessary, you can't do it automatically.
Let me know if you want to go that route.

bod1467

@rmg1 - I think you're right.

@Owain - that page is blank for me too - in Chrome. In IE9 it loads fine.

robmar0se

Just a comment from a practical aspect, and may solve the problem too.

If you were successful in changing column widths automatically, then if you wanted to print the spreadsheet, you might have probs on what showed on each page etc.?

Might it be better to use cell wrap so that if the data was too long for the column, it just makes the cell /row deeper and data then goes underneath. If you made the change to the column, then saved it, it would be automatic each time you opened the spreadsheet. Would this do the job just as well?

rmg1

If you want everything on one line, then you could set up a print area for the relevant bits you wanted to print, and then set up the page at (for example) 1 page wide and X long (you can leave that bit blank so it prints as many pages as necessary).

robmar0se

rmg1 wrote: »

If you want everything on one line, then you could set up a print area for the relevant bits you wanted to print, and then set up the page at (for example) 1 page wide and X long (you can leave that bit blank so it prints as many pages as necessary).

On A4 portrait , depending on font size, but typically 80 characters per row, or 130 landscape, if my memory serves me correctly.

So depending on how wide the columns might be the OP may go over which is always a bind - so I have found the "wrap text" format the best way to resolve this issue, it would be automatic, just highlight the column, format and save. NB there is also the "shrink to fit" format option, etc,,,,,,,,,,,

However if the OP insists on one line with variable column sizes the OP has the print rsik, and the hassle of trying to make it automatic.

I guess the OP can decide...............

rmg1

@robmar0se - good point, well made. We can only wait to see what develops.

Owain_Moneysaver

bod1467 wrote: »

that page is blank for me too - in Chrome. In IE9 it loads fine.

Suspicious people might think that Microsoft were using a non-standards-compliant website to lock people in to their products. :mad:

VoucherMan

bod1467 wrote: »

that page is blank for me too - in Chrome

Came up fine for me in Chrome.

For things like column autowidth I still prefer the old Excel 2003 keyboard shortcut though.
I find <Alt> - O - C - A much easier than using the ribbon menus

Jo4

When I view some websites the link I click changes colour so the next time I view the site I know where I have clicked before. Can anyone tell me how to change this setting so links remain the colour they originally were?