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


USA Landscape Photographer of the Year 2016 open to entries NOW!

Excel spreadsheet help


Take-a-View 12 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 Plus
9 4.3k 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 12 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 Plus
9 4.3k 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 12 293 5 United Kingdom
5 Mar 2009 8:16PM
Cheers. Have PM'd you
rowarrior 8 4.4k 9 Scotland
5 Mar 2009 8:30PM
If you can't click into them then the cells are locked
Take-a-View 12 293 5 United Kingdom
5 Mar 2009 8:52PM
No cells visible
Nick_w Plus
9 4.3k 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 12 293 5 United Kingdom
5 Mar 2009 10:33PM
Thanks to Nick and Rowarrior for responding..............all finally sorted.

Cheers
Take-a-View 12 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.