If you want to hide or unhide rows or columns, either to fit them on a screen or print your worksheet on a single page, you can do it in Excel in a few different ways.
Hide rows or columns
In order to hide rows or rows, follow these steps.
- Select the rows you want to hide.
- Right-click one of the selected rows and choose Hide.
Now, the selected rows are hidden. The remaining six rows are still visible.
Normally, row numbers or column labels are separated by a single line. If there is a double line, instead of a single, it means that there are some items hidden.
In a similar fashion, you can hide columns.
- Select the columns you want to hide.
- Right-click one of the selected column labels and click Hide.
Unhide rows or columns
To unhide the hidden values, select two-row numbers below and above the hidden items and click Unhide.
To unhide columns, click column labels on the left and right of the hidden columns and click Unhide.
Hide rows or columns with a shortcut
You can also hide rows and columns with a keyboard shortcut.
You can use Ctrl + 9 to hide rows, and Ctrl + 0 to hide columns.
If you select a few rows and use Ctrl + 9, it will hide these rows.
But you have to be careful if you choose Ctrl + 0 (hide columns) instead it will hide all columns. In this case, in each column there are four cells selected, therefore all columns will be hidden.
Instead of selecting entire rows or columns, you can select a single cell.
If you choose cell C7 and then Ctrl + 9, it will hide row 7. If you use Ctrl + 0, it will hide column C.
Unhide rows or columns with a shortcut
You can also use a keyboard shortcut to unhide hidden rows and columns.
Ctrl + Shift + 9 – unhide rows
Ctrl + Shift + 0 – unhide columns
Kama unataka kuficha au unhide safu au safu, ama fit yao juu ya screen au kuchapisha karatasi yako juu ya ukurasa mmoja, unaweza kufanya hivyo katika Excel katika njia kadhaa tofauti. Ficha safu au safu Ili kuficha safu au safu, fuata hatua hizi. - Chagua safu unataka kuficha. - Right-click moja ya safu iliyochaguliwa na kuchagua Ficha. Sasa, safu zilizochaguliwa zimefichwa. Safu sita zilizobaki bado zinaonekana. Kwa kawaida, nambari za safu au lebo za safu hutenganishwa na mstari mmoja. Kama kuna mstari mara mbili, badala ya moja, inamaanisha kwamba kuna baadhi ya vitu siri. Kwa njia sawa, unaweza kuficha safu. - Chagua safu unataka kuficha. - Right-click moja ya alama ya safu iliyochaguliwa na bonyeza Ficha. Unhide safu au safu Ili kuficha maadili kufichwa, kuchagua namba safu mbili chini na juu ya vitu kufichwa na bonyeza Ficha. Kuficha safu, bonyeza safu lebo upande wa kushoto na kulia wa safu siri na bonyeza Ficha. Ficha safu au safu na njia ya mkato Unaweza pia kuficha safu na safu na njia ya mkato keyboard. Unaweza kutumia Ctrl + 9 kuficha safu na Ctrl + 0 kuficha safu. Ikiwa unachagua safu chache na kutumia Ctrl + 9, itaficha safu hizi. Lakini unapaswa kuwa makini kama wewe kuchagua Ctrl + 0 (kuficha safu) badala yake itakuwa kuficha safu zote. Katika kesi hii, katika kila safu kuna seli nne kuchaguliwa, kwa hiyo safu zote itakuwa siri. Badala ya kuchagua safu nzima au safu, unaweza kuchagua seli moja. Ikiwa unachagua C7 na kisha Ctrl + 9, itaficha safu ya 7. Ctrl + 0 - Hide safu C: Unhide safu au safu na njia ya mkato Unaweza pia kutumia njia ya mkato ya kibodi kufuta safu na safu zilizofichwa. Ctrl + Shift + 9 <unk> unhide safu <unk> Ctrl + Shift + 0 <unk> unhide safu