Often now I type it in full because it is faster than to search and hope. So I am living with three kind of surprise options. So I understand that the Microsoft guys have some problem with it.Īsking for my date in excel, sometimes it does with the : sometimes with the. Living just in the english world does not really have those problems. So, I am kind of a hardware software language pioneer trying to sort out my crosscultural language minutely changing computer system. So if I do french all day I could adjust to but like this it is a bit nasty. I do some french but that's nasty on that keyboard (you know these accontegraphs and güs and so - that's difficult - especially in google translator, it is always asking the french keyboard.
Now I am german, english speaking, living in Ukraine and learning ukrainian as 3rd language, that's still some challenge for the windows world. I have but to say I am german, have a Ukrainian Laptop with (most probably russian) Windows set to english, (still always russian comments popping up, so I guess it is a russian windows they sold me) - english set Excel 365 and 3 languages permanently in use on an dual language qwerty english keyboard (especially with imprints for the ukrainian language) and using the Microsoft Keyboard Layout creator for adjusting some keys from russian use to ukrainian. With me sometimes it works just fine but sometimes it does not. So, sometimes, it can be useful to try a mentionned shortcut from the online help in both combinations (Shifted/Unshifted) depending from the keyboard you for the answer.
But from an en_US keyboard layouts' perspective, Ctrl+Shift+# is correct. This is due to that # is on a german keyboard reachable without pressing the shift key. This does not work, I have to use Ctrl+#. An example: for applying a date format, the German Online Article mentions that I can use Ctrl+Shift+#. Therefore, the mentionned shortcuts (keystrokes) can lead to confusion and may be appear as incorrect. There is a note about this on the top of the article. I already reported this to the MS localization team and they are going to check this.Īnother problem in the online help article for the shortcuts (at least for German) is, that the shortcuts always refer to an English US keyboard. So, in this case, it's for now an error in online help article regarding Ctrl+Semicolon.įor Excel 2016, there are some more errors in the Online Help Article for the German shortcuts, such as some Alt shortcuts, for example Alt+M which opens the Tell Me Box instead of the formulas tab. For inputting the current date in an empty cell, I can use Ctrl+Dot as known from previous versions.
Learn how to fit a worksheet to one page in Excel 2013 without needing to manually adjust the size of your rows or columns at all.I have Excel 2016 in German and I am using a german keyboard. If your Excel spreadsheet is difficult to print, then consider adjusting the scale. Step 6: Repeat steps 2 – 4, then press Alt + a to use the AutoFit Row Height function. Step 5: Press Alt + i to use the AutoFit Column Width function. Step 4: Press Alt + o to open the Format menu. Excel supports a plethora of keyboard shortcuts that help you work efficiently and increase productivity. Let’s dive deep into the Excel shortcuts that can help us work better on an Excel spreadsheet. Step 3: Press Alt + h to select the Home tab. Various operations can be achieved with a few simple keyboard strokes. Step 2: Press Ctrl + A on your keyboard to select the entire worksheet. Control + B for bold), since dedicated shortcuts are faster than ribbon shortcuts. This doesnt matter much when youre performing an action that has a dedicated shortcut (i.e. Step 1: Open your worksheet in Excel 2013. In Excel on Windows, you can use so called accelerator keys to access almost every command in Excel using only your keyboard. These steps are also shown below with pictures – Repeat steps 2, 3, and 4 to get back to the Format menu, then press Alt + a to use the AutoFit Row Height command.Press Alt + i to use the AutoFit Column Width command.Press Ctrl + a to select the entire worksheet.Here is how to use keyboard shortcuts to AutoFit rows and columns in Excel 2013 – The result of following these steps will be a worksheet where all of the row heights and column widths have been adjusted to fit the largest piece of data in that row or column.
The steps in this article are going to show you a series of keyboard shortcuts that will allow you to use the AutoFit commands to automatically resize all of the columns and rows in your worksheet.
Our guide below will show you how to get to them without needing to use your mouse.Īutofitting Rows and Columns in Excel 2013 Without Using Your Mouse Copying and pasting, for example, is one action that can be made much quicker by using a keyboard instead of a mouse.īut there are keyboard shortcuts for many more Excel functions, including the AutoFit Column Width and AutoFit Column Height commands. Excel can be a lot easier to use once you get comfortable using keyboard shortcuts to perform common actions.