STRG + : ( Doppelpunkt ) aktuelle Uhrzeit einfügen STRG + * markieren des aktuellen Bereichs STRG + & Zahlenformat "Standard" zuweisen STRG + % Zahlenformat "Prozent ohne Dezimalstellen" zuweisen STRG + $ Zahlenformat "Währung + 2 Nachkommastellen" zuweisen STRG + # Wechseln der Anzeige zwischen Zellwerten und Zellformeln STRG + " Zahlenformat "Wissenschaft mit 2 Nachkommastellen" zuweisen STRG + ! Zahlenformat "Zahl mit Tausendertrennzeichen, 2 Dezimalstellen + Vorzeichen" zuweisen SHIFT + Rücktaste Reduzierung der Markierung auf die aktuelle Zelle SHIFT + POS1 Erweitern der Markierung bis zum Zeilenanfang SHIFT + Pfeiltaste Erweitern der Markierung um eine Zelle
![how to extend underline in excel how to extend underline in excel](https://1.bp.blogspot.com/-VAblaj27z3o/XUAaEzok6KI/AAAAAAAAQbY/BOqGBMleoXQA9DwZuXhFOc_3wq6fLZ1EACLcBGAs/s1600/shorcut.png)
SHIFT + Leertaste gesamte Zeile markieren SHIFT + BildAuf Erweitern der Markierung um eine Bildschirmseite nach oben SHIFT + BildAb Erweitern der Markierung um eine Bildschirmseite nach unten SHIFT + F9 Aktives Tabellenblatt berechnen SHIFT + F6 Wechseln zum vorherigen Ausschnitt SHIFT + F3 Einfügen einer Funktion in eine Formel Here are some short-cuts - sorry, but only in germanĪLT + (Pfeil nach unten) Anzeige der AutoEingabe - ListeĪLT + EINGABE Zeilenumbruch innerhalb einer Zelle You may want to remember a few to boost your productivity. These are very useful and extremely time saving ones. Note: I have *ed some of the most important shortcuts. Here is the complete list of excel keyboard shortcuts. Without you I couldn’t have learned these shortcuts. Special thanks to all the commenters on the original post. Here is the complete list of Excel Keyboard Shortcuts. During the weekend, I spent sometime to collect all these beautiful shortcuts and arranged them neatly so that you can easily learn them. There were so many wonderful keyboard shortcuts and tricks buried in the comments section of that post. More than 50 people commented on that post and shared a hundred excel keyboard shortcuts with us.
HOW TO EXTEND UNDERLINE IN EXCEL UPDATE
This is an update of a post from December 2010.Few weeks back I have invited all of you to share your excel keyboard shortcuts in a open thread. And for totals, select your cell(s) and click the down arrow next to the underline button on the ribbon, You’ll find a choice there for double underline. (If you underline first, it won’t work.) In Excel this is called Accounting Underline. Or will it? If you first format cells with either the comma format or the accounting format and then format the text as underlined, the underline will extend almost the entire width of the column.
![how to extend underline in excel how to extend underline in excel](https://1.bp.blogspot.com/-QhnirSiWdHQ/XQ5KTMjMfnI/AAAAAAAACIA/kdXEbkMFsYwh4ccW_BqHwNAoZbbdUw8yQCPcBGAYYCw/s1600/IMG-20190609-WA0039.jpg)
You could format the text in the headings to be underlined, but then the line will only be as wide as the text or numbers in the cell. But that is tedious to set up and interferes with using the ctrl+arrow or End+arrow keyboard shortcuts.
![how to extend underline in excel how to extend underline in excel](https://excelnotes.com/wp-content/uploads/2020/02/shortcutCtrlU-1200-1024x580.jpg)
A common solution is to have very narrow empty columns between the columns of data. But for totals or subtotals, many people don’t like the continuous line that it creates they would prefer a separate underline in each column. Putting a bottom border on a row of cells can be a good choice for column headings on a spreadsheet.
![how to extend underline in excel how to extend underline in excel](https://www.excelarticles.com/image/LE10001177.jpg)
Most people that I’ve shown this to are just as surprised as I was when someone first showed me. Today’s Excel tip is very simple, but it can save a lot of time when formatting a spreadsheet.