Take your photography to the next level and beyond...

  • NEWS
  • REVIEWS
  • INSPIRATION
  • COMMUNITY
  • COMPETITIONS

Why not join for free today?

Join for Free

Your total photography experience starts here


Excel spreadsheet help


Take-a-View e2
10 293 5 United Kingdom
5 Mar 2009 7:32PM
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.

Nick_w e2
7 4.1k 99 England
5 Mar 2009 8:07PM
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).
Take-a-View e2
10 293 5 United Kingdom
5 Mar 2009 8:13PM
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
Nick_w e2
7 4.1k 99 England
5 Mar 2009 8:14PM
Yes no problem - If you want I can have a look at it for you - been looking at spreadsheets all afternoon!
Take-a-View e2
10 293 5 United Kingdom
5 Mar 2009 8:16PM
Cheers. Have PM'd you
rowarrior e2
7 4.4k 9 Scotland
5 Mar 2009 8:30PM
If you can't click into them then the cells are locked
Take-a-View e2
10 293 5 United Kingdom
5 Mar 2009 8:52PM
No cells visible
Nick_w e2
7 4.1k 99 England
5 Mar 2009 9:00PM
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.
Take-a-View e2
10 293 5 United Kingdom
5 Mar 2009 10:33PM
Thanks to Nick and Rowarrior for responding..............all finally sorted.

Cheers
Take-a-View e2
10 293 5 United Kingdom
15 Mar 2009 5:50PM
Thanks to Artois for "cracking" the problem

Sign In

You must be a member to leave a comment.

ePHOTOzine, the web's friendliest photography community.

Join For Free

Upload photos, chat with photographers, win prizes and much more.