Upload your photos, chat, win prizes and much more
Can't Access your Account?
New to ePHOTOzine? Join ePHOTOzine for free!
Upload photos, chat with photographers, win prizes and much more for free!
I'm using excel 2007 and trying to adapt an existing worksheet. However, the columns/cells outside the existing page (columns A-F) cannot be accessed and I cannot enter data or insert additional columns into the sheet. The headings row run from A to F and then blank and there are no cells to enter data into.
Join ePHOTOzine for free and remove these adverts.
Have you looked to see if the cells/columns are hidden? Right click then select unhide.
Alternatively if you only want the data you can see and want to add data etc select all the data, copy (CTRL+C) goto a new worksheet goto A1 then paste (CTRL+V).
Nothing is hidden but after the last column the remainder of the sheet is blank and I can't even click onto a cell! Will PM you if that's ok
Yes no problem - If you want I can have a look at it for you - been looking at spreadsheets all afternoon!
Cheers. Have PM'd you
If you can't click into them then the cells are locked
No cells visible
Ian I copied the cells OK into a new sheet - Just noticed when I opened it its linked to numerous external workbooks (not sheets) it probably contains quite sophisticated visual basic code / macros be careful with using sheets like this, its often how viruses infect your M/C. Some of the links look very suspicious.
Thanks to Nick and Rowarrior for responding..............all finally sorted.
Thanks to Artois for "cracking" the problem
ePHOTOzine, the web's friendliest photography community.
Upload photos, chat with photographers, win prizes and much more.
You must be a member to leave a comment
Get the latest photography news straight from ePHOTOzine in your email every month and win prizes!
01/09/2014 - 30/09/2014
Check out ePHOTOzine's inspirational photo month calendar! Each day click on a window to unveil new photography tips, treats and techniques.
View September's Photo Month Calendar