Mrrrr's Forum (VIEW ONLY)
Un forum care ofera solutii pentru unele probleme legate in general de PC. Pe langa solutii, aici puteti gasi si alte lucruri interesante // A forum that offers solutions to some PC related issues. Besides these, here you can find more interesting stuff.
|
Lista Forumurilor Pe Tematici
|
Mrrrr's Forum (VIEW ONLY) | Reguli | Inregistrare | Login
POZE MRRRR'S FORUM (VIEW ONLY)
Nu sunteti logat.
|
Nou pe simpatie: Stefania_h0t
| Femeie 24 ani Salaj cauta Barbat 24 - 46 ani |
|
Mrrrr
AdMiN
Inregistrat: acum 17 ani
Postari: 2189
|
|
Source
For screenshots please go to the link above.
If you use Excel 2007, 2010 or Excel 2013, it is easily for you to remove the unwanted hidden rows or columns. You can do it as follows:
1. If you use Excel 2007, please click Office Button on the top left corner, and then click Prepare > Inspect Document. If you use Excel 2010/2013, please click File > Info > Check for Issues > Inspect Document.
2. Then a Document Inspector dialog box will appear, click Inspect button.
3. The "hidden rows or columns" in the whole workbook have been inspected and if there are any, there is a "REMOVE ALL" button next to them.
4. Click Remove All, then click Close button. And all of the hidden rows and columns in the workbook will be removed.
Note: A. If there are formulas to manipulate the data in your workbook and the formulas call for data from hidden rows and columns, then deleting that information will cause incorrect result. B. With this function, you can delete all of the hidden rows and columns in the whole workbook.
_______________________________________
|
|
pus acum 10 ani |
|