Excel

Highlighted
Tammy4765
Occasional Visitor

I currently have a spread sheet with 12 columns and 10 rows. I am trying to center the actual text box in each cell. I know how to center the text in the box but I need the text Box to be centered in the entire spreadsheet. Thanks!

1 Reply

@Tammy4765 

Add text to the first cell, select the range in the row, Ctrl+1 and Center across selection

image.png 

Related Conversations
Copy/paste no longer working in Excel
Jon Firooz in Excel on
76 Replies
changing Date format in a pivot table
ahmad ali in Excel on
12 Replies
runtime error 1004 : Method range of object - 'Global' failed
Lorenzo Kim in Excel on
16 Replies
INDEX & MATCH interrupted by Inconsistent Dates
shade206 in Excel on
18 Replies
Need to extract values from named cells (Get and Transform)
JEMagnussen in Excel on
23 Replies
Creating tables and linking data
Sukhayanti in Excel on
10 Replies