Hi Vaibhav, Here are the steps to set the first row as the header.
1. Select the entire region containing the data on the spreadsheet. By default content of a spreadsheet is not technically a table. 2. Format the selected region as a table. Go to Home tab -> Styles-> Format as table. 3. Select a table format and check the checkbox ‘My table has header’. This will make the first row of the selected area as the header. Hope this helps. Alok From: accessindia@accessindia.org.in [mailto:accessindia@accessindia.org.in] On Behalf Of Vaibhav Saraf Sent: 07 June 2021 08:11 To: accessindia@accessindia.org.in Subject: [AI] MS Excel query - making column headers to be announced by the screen readers Hi Friends, I have seen some excel sheets in the past which announce the row 1 content as column headers when you move between columns. For example - If you move from cell B3 to C3, then the screen reader announcement will be the value of C3 + the column heading which is generally the content of C1. I am not sure how to do this. Found a few directions on Google which do not work. Can anyone help me with the required process to set a cell as header? Thanks, Vaibhav -- Disclaimer: 1. Contents of the mails, factual, or otherwise, reflect the thinking of the person sending the mail and AI in no way relates itself to its veracity; 2. AI cannot be held liable for any commission/omission based on the mails sent through this mailing list.. Search for old postings at: http://www.mail-archive.com/accessindia@accessindia.org.in/ --- You received this message because you are subscribed to the Google Groups "AccessIndia" group. To unsubscribe from this group and stop receiving emails from it, send an email to accessindia+unsubscr...@accessindia.org.in <mailto:accessindia+unsubscr...@accessindia.org.in> . To view this discussion on the web visit https://groups.google.com/a/accessindia.org.in/d/msgid/accessindia/CAAx3Jh2EaEiKsC_BKM0HbCkq7w_o8K4wh1d%3DG3%2BwB9x-tWAq0w%40mail.gmail.com <https://groups.google.com/a/accessindia.org.in/d/msgid/accessindia/CAAx3Jh2EaEiKsC_BKM0HbCkq7w_o8K4wh1d%3DG3%2BwB9x-tWAq0w%40mail.gmail.com?utm_medium=email&utm_source=footer> . -- Disclaimer: 1. Contents of the mails, factual, or otherwise, reflect the thinking of the person sending the mail and AI in no way relates itself to its veracity; 2. AI cannot be held liable for any commission/omission based on the mails sent through this mailing list.. Search for old postings at: http://www.mail-archive.com/accessindia@accessindia.org.in/ --- You received this message because you are subscribed to the Google Groups "AccessIndia" group. To unsubscribe from this group and stop receiving emails from it, send an email to accessindia+unsubscr...@accessindia.org.in. To view this discussion on the web visit https://groups.google.com/a/accessindia.org.in/d/msgid/accessindia/006801d75bdf%24f357c850%24da0758f0%24%40gmail.com.
