Formatting not working

Allan Paterson

New Member
Joined
Nov 14, 2004
Messages
8
Hi,

I've been given data in an Excel spreadsheet downloaded from our ERP system (INFOR System 21, formerly GEAC) into Access and then outputted into Excel.

Now the formatting (right click, choose Format Cells) doesn't work?

So I can't highlight the data that needs to be worked on?

Any ideas?

Thanks.
 

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying
Now the formatting (right click, choose Format Cells) doesn't work?
"doesn't work" can mean a lot of things
please describe your problem:
is the option greyed out or is the format just not working as expected ?
 
Upvote 0
Formatting doesn't work

Hi,

Sorry I meant when you right click and get the option "Format Cells" and you then click on it, instead of getting the format box you get nothing at all, it is as if you hadn't clicked the option?

Thanks, Allan
 
Upvote 0
Hi Allan Paterson:

Try copying and *1 then pasting a portion of your sheet to a new range and see if you can format that new range.

plettieri
 
Upvote 0
Allan,

that's strange

so the option is not greyed out, but there is no box
and it is still working within other spreadsheets

I'm out if resources: perhaps seeing your sheet could help. Feel free to send part of your worksheet by email, so I can take a look...

best regards,
Erik
 
Upvote 0
Hi,

Thanks, I think I've solved it - If you format using the toolbar tools (colour coding for example) suddenly the right click and Format cell function works again! So all I did was highlight the whole area colour yellow and then change back to "none" and I could format as normal.

Our IT dept thinks that going from our ERP to Acess to Excel set some flags and this could have been avoided by saving the Access output as a CSV file first then saving in Excel but I've not tried that due to the simpler solution (from my point of view) above.

Anyway thanks for your help.

Allan
 
Upvote 0

Forum statistics

Threads
1,213,513
Messages
6,114,064
Members
448,545
Latest member
kj9

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top