Hiding a row or column is also useful if you are showing someone a worksheet that contains private or sensitive data that you do not want the person to see.
Archive of posts filed under the How to category.
員工不聽話是老闆的錯
如 果 你 是 一 位 訓 狗 師，經 你 訓 練 出 來 的 狗，不 但 亂 咬 東 西，還 亂 大 小 便 和 亂 咬 人，然 後 你 跟 我 說 這 是 狗 的 錯，我 會 相 信 你 嗎 ？ 我 以 後 還 會 請 你 這 位 訓 狗 師 嗎 ？ 子 不 孝，父 之 過。狗 不 聽 話，訓 狗 師 之 過 也。
The Secret Of .XLSX File
The new .xlsx file format is actually a ZIP file in disguise. It’s composed of several files that are compressed and then packaged together as a single unit
Adding VBA Macros to the Quick Access Toolbar
Step by step instruction to guide you adding VBA macro as icon in Quick Access Toolbar, QAT.
Change Excel’s Default File Location
Excel saves every new workbook in the My Documents folder. Many times it is not practical for many users. Learn how to change the default file location folder.
Pinning Application Shortcut To The Windows Start Menu
The fast method to run your application is to launch it from the Start Menu. Learn how to pin your frequent use application to Windows Start Menu quickly
How to Open Workspace Automatically Whenever Excel Launches?
When you know that you’ll be using a particular workspace for some time in your Excel work, you can speed up the process of setting up your work environment by having Excel automatically open the workspace file when you launch the program.
Tips To Make New Excel Ribbon Behave Like Legacy Menu
While there is nothing you can do to bring back the legacy Excel menu and toolbars, you can make the ribbon behave a bit more like a old style menu.
Navigating Workbook | Show and hide Excel Windows
Beginning with Excel 2007, workbook “files” are actually compressed folders. Inside the compressed folders are a number of files that hold all the information about your workbook, including charts, macros, formatting, and the data in its cells.
Use Keyboard To Enter Excel Formulas Quickly
Learn this simple and easy method to perform formula entry in Excel to save you time from data entry.