Excel Keyboard Commands

[louie-prog]

Good day to all NVDA users. May I know if is it possible to drag the cells in excel using keyboard to increase its size? The NVDA is saying either cropped or over flowing? What does it mean?
Thank you for your response.

[Qchristensen]

You can adjust cell size using the ribbon. There are several options:

1. You can manually set the column width using ALT+H, then O, then W. Then type a value.
2. You can autofit the width to the contents, by pressing ALT+H, then O, then i.

When manually setting column width, you can use the same command, alt+h, o, w, to simply open the column width dialog and read the existing value - that way when wanting to set a value, you can check other nearby cells to know how large they are.

Autofit sets the cell width to as wide as needed to fit the current contents. Usually the best way to do this is to first press CONTROL+SPACEBAR to select the whole column, that way autofit will set to the widest cell in the column. You can do the same thing for row height as well, again these are on the cell formatting option in the home ribbon - alt+h, then o.

If you are interested, all of this and much more is covered in the Microsoft Excel with NVDA training module available at: https://www.nvaccess.org/product/microsoft-excel-training-for-nvda-ebook/

[louie-prog]

Glad to know this. Thanks.

…

On 11/17/21, Quentin Christensen ***@***.***> wrote: You can adjust cell size using the ribbon. There are several options: 1) You can manually set the column width using ALT+H, then O, then W. Then type a value. 2) You can autofit the width to the contents, by pressing ALT+H, then O, then i. When manually setting column width, you can use the same command, alt+h, o, w, to simply open the column width dialog and read the existing value - that way when wanting to set a value, you can check other nearby cells to know how large they are. Autofit sets the cell width to as wide as needed to fit the current contents. Usually the best way to do this is to first press CONTROL+SPACEBAR to select the whole column, that way autofit will set to the widest cell in the column. You can do the same thing for row height as well, again these are on the cell formatting option in the home ribbon - alt+h, then o. If you are interested, all of this and much more is covered in the Microsoft Excel with NVDA training module available at: https://www.nvaccess.org/product/microsoft-excel-training-for-nvda-ebook/ -- You are receiving this because you authored the thread. Reply to this email directly or view it on GitHub: #13065 (comment)