ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I sort a database without also sorting the column heading? (https://www.excelbanter.com/excel-discussion-misc-queries/238828-how-do-i-sort-database-without-also-sorting-column-heading.html)

Nikki Carter Johnson

How do I sort a database without also sorting the column heading?
 
Hi, I've created a datase and I'm trying to sort it alphabetically, but for
some reason the titles at the top of the columns are also sorting. How do I
format the database so that Excel knows that the column headings are titles?
Your help would be much appreciated. Thanks, Nikki

Jacob Skaria

How do I sort a database without also sorting the column heading?
 
From menu DataSort window under the label 'My data range has' check "Header
row'

If this post helps click Yes
---------------
Jacob Skaria


"Nikki Carter Johnson" wrote:

Hi, I've created a datase and I'm trying to sort it alphabetically, but for
some reason the titles at the top of the columns are also sorting. How do I
format the database so that Excel knows that the column headings are titles?
Your help would be much appreciated. Thanks, Nikki



All times are GMT +1. The time now is 09:50 PM.

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