Would like to lock part of an excel document

July 29, 2020 at 14:51:02
Specs: Windows 10
I would like to know if there is a way to create a document in excel where the top part of the document is text and the bottom part of the document is a table. I would like to be able to add and delete columns in the table and adjust the size of the columns without affecting the text that is above it. I can send an example if that helps. Thank you!

See More: Would like to lock part of an excel document


#1
July 29, 2020 at 15:40:03

Reply ↓  Report •

#2
July 29, 2020 at 15:40:42
Yes a sample would help.

Reply ↓  Report •

#3
July 30, 2020 at 06:47:35
This appears to be another case where I get to remind folks that Excel is not a word processing application. While certain text-related features and functions are available, it's strength is in the data calculation arena.

Have you tried using Merge and Center for the text? This should allow for some flexibility as far as adding and deleting columns in the table. However, AFAIK changing the width of column is done at the sheet level, not the table level. i.e. you can't make E6:E10 (a column in your table) wider than E1:E4 (your text). You can only adjust the width of E:E (the entire column)

Perhaps there is a way to "float" a table over the spreadsheet, i.e. as an object. I'll look into that.


message edited by DerbyDad03


Reply ↓  Report •

Related Solutions

#4
July 30, 2020 at 07:24:32
In Word one can create sections - each with its own formatting etc. Iis that possible in Excel?

Reply ↓  Report •

#5
July 30, 2020 at 08:00:06
Haven't tried to overlay any kind of text,
but you could just take a picture/screenshot of the text and overlay the picture.

MIKE

http://www.skeptic.com/


Reply ↓  Report •

#6
July 30, 2020 at 08:26:09
Just as a side note, if you don't want to take a screenshot
you can also insert an object as a Office Word Document
and actually type in the information you want.

This is probably the closest to what your looking for.
You will still have the ability to resize columns & rows beneath the document.

Edit:
You could also insert a Text Box which is similar to inserting a Word Doc,
it will allow you to type in your text but still allow you to resize cells.

MIKE

http://www.skeptic.com/

message edited by mmcconaghy


Reply ↓  Report •

#7
July 30, 2020 at 10:24:13
Try the Camera tool in Excel.

You would place your table on another sheet and paste a "live picture" on the sheet with the text. When you update the actual table, the picture will update also.

I tried it and it works!

Add the Camera via the Quick Access toolbar...More Commands then All Commands list.

Select the table, click the Camera icon and paste the live image anywhere you want.

Note: double clicking the image gets you to the underlying range.

message edited by DerbyDad03


Reply ↓  Report •

Ask Question