how to format an excel spreadsheet so text copy can be entered easily

vickymcveigh

New Member
Joined
Nov 30, 2016
Messages
2
Hi,
I have created an excel spreadsheet to be used as a product specification sheet (basically a one page document which holds all pricing details / weights etc for each product we sell).

I need to include on it a product description, which will be around 2/3 short paragraphs of text. the people completing this spreadsheet are very basic users.

I have formatted the cell so its wrapped text with centre alignment, but when you start entering the product description, and press enter to start a new paragraph, it obviously moves the highlighted cell down, which screws up the rest of the spec sheet.

is there a way around this, or does anyone have any suggestions? thank you!
 

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

Forum statistics

Threads
1,191,517
Messages
5,987,063
Members
440,074
Latest member
Emmanuelian

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top