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

EchoLocation

Jo4 wrote: »

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?

This is actually a browser default action, although many websites specify their own actions for 'visited' links. You can set your own colours for links - (Firefox) Tools > Options > Content > Colours... Link Colours: - although I'm not sure if it's possible to tell the browser to ignore just the coding for visited links, at least not without a custom stylesheet.

Jo4

EchoLocation wrote: »

This is actually a browser default action, although many websites specify their own actions for 'visited' links. You can set your own colours for links - (Firefox) Tools > Options > Content > Colours... Link Colours: - although I'm not sure if it's possible to tell the browser to ignore just the coding for visited links, at least not without a custom stylesheet.

Any idea how to do it in Internet Explorer 9?

Jo4

Jo4 wrote: »

Any idea how to do it in Internet Explorer 9?

Tools > Internet options > General > Appearance > Colors and then untick "Use hover color".

THANKS! :j :beer:

Jo4

I was working on the spreadsheet a few days ago and it would not let me copy the formula into additional cells, know the way the cursor changes to the shape of a cross at the bottom right of the cell and you can then drag it downwards? I was back at the spreadsheet today and it will not let me copy the formula today either unless I do control c and control v.

Any ideas what I have done this time? :eek:

EchoLocation

Jo4 wrote: »

I was working on the spreadsheet a few days ago and it would not let me copy the formula into additional cells, know the way the cursor changes to the shape of a cross at the bottom right of the cell and you can then drag it downwards? I was back at the spreadsheet today and it will not let me copy the formula today either unless I do control c and control v.

Any ideas what I have done this time? :eek:

Tools > Options > Edit > 'Allow cell drag and drop' (check box)

Edit: Not sure if it's called the same thing in Excel 2007 though.

Jo4

EchoLocation wrote: »

Tools > Options > Edit > 'Allow cell drag and drop' (check box)

Edit: Not sure if it's called the same thing in Excel 2007 though.

Thanks but unfortunately it did not work!

In 2007 it is Microsoft Office button > Excel Options > Advanced > Under "Editing Options" make sure "Enable fill handle and cell drag-and-drop" box is ticked.

Thanks for responding!

EchoLocation

Jo4 wrote: »

Thanks but unfortunately it did not work!

So will it not let you drag anything down? or is it just nothing appears once dragged downl?

Do you get the cursor handle appear?

Is the sheet protected?

You say it's a formula, can you drag down just text or number values?

It is the same using the left and right mouse buttons?

Jo4

EchoLocation wrote: »

So will it not let you drag anything down? or is it just nothing appears once dragged downl?

Do you get the cursor handle appear?

Is the sheet protected?

You say it's a formula, can you drag down just text or number values?

It will not let me drag anything down.

The cursor handle does appear.

As far as I know the sheet isn't protected, any idea how I make sure it isn't protected?

I cannot drag text or number values either.

I created a new spreadsheet and entered numbers in it but I can not drag anything in it either!

EchoLocation

Jo4 wrote: »

It will not let me drag anything down. /the ccursor handle does appear. As far as I know the sheet isn't protected, any idea how I make sure it isn't protected? I cannot drag text or number values either.

I created a new spreadsheet and entered numbers in it but I can not drag anything in it either!

Click on the Review tab to see if you can Remove Sheet Protection.

Is it possible there is some VBA code in the file that is disabling Drag and Drop at application level?

If you close your file, open Excel a fresh and create a new workbook, do you still have the same problem?

Jo4

EchoLocation wrote: »

It is the same using the left and right mouse buttons?

When I use the right mouse button and I have clicked on the cell and attempted to drag it down to where I want the formula to be copied, I get the following message "Copy cells" "Fill without formatting".