Hello everyone!,
i have found it difficult to find in excel 2007 something that im sure that i've found before.
i want to create a table that is not affected by the sizes of columns -
sort of like a "picture" table.
im using the word picture because when i found it i remember that after i've inserted the data, Excel stated that i wont be able to change the data anymore and it will count as a picture.
i would be greatful if someone helped me find what im looking for.
thank you!
atai.b
Up!, i really need help about this guys!
thanks again
I don't think there is any native function of Excel that allows for the single entry of data and then it can no longer be changed. You can copy a table as a picture and then it is static;
on the home tab, click on the small arrow under "Paste" to get the dropdown menu. Then "As Picture" > "Copy as Picture"
Hope that helps.
ChemistB
My 2¢
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Maybe you can use the Camera tool to take a picture of your table (which is on a separate sheet). You can change the columns/rows of the sheet where the picture is and the picture will remain unaffected. Not sure about inability to change data, since the picture should be a 'Live' reference to the source cells.
Pauley
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks