Tämän päivän kysymys- ja vastausistunto tulee meihin SuperUserin hyväksi - Stack Exchangein alaosasto, joka on yhteisöllinen Q & A-sivustojen ryhmittely.
Kysymys
SuperUser-lukija jstricker haluaa tietää, kuinka lisätä uudet rivit Exceliin käyttämällä näppäimistöä hiiren sijaan:
Right-clicking on a row and selecting insert is fairly time consuming. I would rather not have to take my hands off the keyboard. How can I insert a new row above my current row using only the keyboard? I am primarily interested in inserting a single row at a time, but would also be interested in answers that address inserting multiple rows at a time.
Onko helppo tapa lisätä uudet rivit Exceliin näppäimistöllä?
Vastaus
Vastauksemme ovat meille SuperUser-toimittajille jstricker, ATG, KRyan, BillOer ja asslias. Ensin, jstricker:
There are two options that I am aware of and both (unfortunately) require two steps.
Option 1
- With a single cell selected, hit Shift + Space to select the row.
- Hit Control + Shift + + (Plus Sign) to insert a row above the current row.
Option 2
- With a single cell selected, hit Control + Shift + + (Plus Sign) to insert a row.
- Hit Enter to accept the default of Shift Cells Down.
If inserting many rows at once, I think the first option is the best since you can repeat the second step without having to re-select the row.
Jälkeen ATG: n vastaus:
The following keyboard shortcut will insert one row above the active cell’s row:
Press Alt + I (Insert), then press R (Row).
On personal computers, use the Keyboard Right-Click Key to emulate a right-click on the current selection.
Additional note from ATG: Substituting C for R will insert a new column.
Sitten KRyan vastaus:
It is worth noting that this is a sequence, not necessarily keys to be pressed simultaneously (see answer from ATG above). You can type Alt, then I, then R and get the same effect.
Seuraa BillOerin vastausta:
You can also select multiple rows and then right-click to insert rows, or you can insert one row and then use Ctrl + Y as many times as you need to insert rows. If you format your spreadsheet as a table, you do not even need to worry about copying your formulas.
Ja lopullinen vastaus assylasta:
On Windows I use:
- Shift + Space to select the current row.
- Keyboard Right-Click Key + I to insert a row.
(*) The Keyboard Right-Click Key looks like this:
Onko jokin asia lisättävä selitykseen? Kuulkaa kommentit. Haluatko lukea lisää vastauksia muilta tech-tajuilta Stack Exchange-käyttäjiltä? Katso koko keskusteluketju täältä.