Format Row & Column Headings

[Papi]

Is there a way to modify the position of the row headings when selected? Default is bottom but depending on the document, preferecne would be either center or top.

 

[mole999]

simple click on the alignment Ribbon ?

 

[Papi]

Thanks Mole999. Unfortunately, that works for selected columns and rows but not for Row headings when turned on in Page Layout - Sheet - Row and column headings. At least I cannot get it to work for the rows that now show when printing only.

 

[mole999]

nope I can't see a way, apart from adding spaces / carriage returns above or below the intended to fake the view

 

[VoG]

Can you explain in detail exactly what you want to do.

 

[Papi]

Hello Peter. The worksheet rows have been changed to either Top Align or Middle Align. A request was made to include Page Layout - Sheet - Row and column headings to be turned on. Some of the rows are quite high as some of the data is more like a book than a spreadsheet. I was hoping to somehow set the rows that show row numbers when printing to format to match the row formatting. Does this make sense?