I have really struggled to find a solution on the net but to no avial. I have a date column [spreadsheet B]with the date linked to another spreadsheet A. The date format in both are dd/mm/yyy. In the spreadsheet B ...

This might sound silly but i need help with this one, i have a spreedshet that in a cell contains information and i will like to have part of it in a font color and the other part in a ...

How do I remove trailing zeroes in Excel 2010? I want to remove the last two zeroes from the entire column. For example I want 703100 to look like 7031. Thanks!

I just used some macros in my spreadsheet to paste data in visible cells. I’d like to upload the file to other application which only accept the file .xlsx like without macros. So how do i convert the file xlsm to ...

A user in our business has reported that every word doc he has gives the same error when he tries to open, some docs are over 4 years old, some are only a week old. The error happens wether he ...

Hello, Before I used Lotus Notes and when I had a block of text I didn’t want to see right away I inserted a “breakline”. Inside that ‘line’ I was able to put the block of text. The body of ...

I have a spreadsheet in Excel 2007 which for presentation reasons has narrow columns. I want users to be able to make selections using dropdown lists but the names in the dropdown lists are longer than can be displayed in ...

If I try to select a column, example E, it automatically highlights E & F and when I try Ctrl click to highlight only E and try to delete the column, I get a message “Cannot use that command on ...

Excel spreadsheet Widths across columns in centimetres Lengths down rows in centimetres Price per metre in separate cell Want to fill in sheet with price per sq metre for the dimensions I know it will be easy when I know how !?