ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   HOW TO REVERSE THE ROW OR COLUMN HEADINGS (https://www.excelbanter.com/excel-worksheet-functions/59123-how-reverse-row-column-headings.html)

don

HOW TO REVERSE THE ROW OR COLUMN HEADINGS
 
my row and column headings have been somehow defaulted to appear on the right
hand side of the worksheet ... that is the alphabet ascends from left to
right & the numbers ascend from top down o.k., but they're on the right hand
side of the worksheet

bpeltzer

HOW TO REVERSE THE ROW OR COLUMN HEADINGS
 
Check Tools Options. On the International tab, there's a setting for the
'default direction.' (Even if it shows left-to-right, you might try changing
it, exiting, then changing it back).

"don" wrote:

my row and column headings have been somehow defaulted to appear on the right
hand side of the worksheet ... that is the alphabet ascends from left to
right & the numbers ascend from top down o.k., but they're on the right hand
side of the worksheet


don

HOW TO REVERSE THE ROW OR COLUMN HEADINGS
 
B Peltzer you are awesome ! Can't tell you how valuable your solution was to
us. We had spent literally hours trying to 'logic' out the correct settings,
but would NEVER have thought to look under the International tab.

Many, many thanks

Don

"bpeltzer" wrote:

Check Tools Options. On the International tab, there's a setting for the
'default direction.' (Even if it shows left-to-right, you might try changing
it, exiting, then changing it back).

"don" wrote:

my row and column headings have been somehow defaulted to appear on the right
hand side of the worksheet ... that is the alphabet ascends from left to
right & the numbers ascend from top down o.k., but they're on the right hand
side of the worksheet



All times are GMT +1. The time now is 10:39 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com