Provides Professional Knowledge about Password/Data Recovery and Product Key

How to Add or Delete Pop-up Message Box to Excel Cell

If you want to add any description for any cell you select in Excel, pop-up message box is undoubtedly a good choice. With VBA code, you could easily create or delete pop-up message box to excel cell. Add or Remove Pop-up Message Box to Excel Cell Using VBA Code Step 1: Open worksheet with cells […]

How to Extract Images from Comments in Excel

In Excel, you can insert image into comments box in Excel, but do you know how to extract them easily from comment box when you need these pictures? This post will introduce how to do with an easy way. Extract and save images from comments into a folder with Save As function Step 1:  Copy […]

How to Disable Excel Forgotten Password to Open and Edit Excel File

If your excel file is protected with password, and you want to open and edit it, how can you do if you don’t remember the excel file open and edit password? I think you can learn to disable excel password if you really want to open and edit excel file without knowing password. Section 1: […]

,

How to Delete or Remove Blank Cells/Rows/Columns in Excel

If there are some blank cells, rows, or columns that make your excel data seems not so easy to read or edit, you can try to delete or move them manually and accurately. But if the excel file is large, and there are several excel spreadsheets in it, probably manual deletion would waste you lots […]

How to Print an Excel Worksheet with Comments

If your worksheet contains any import comments and you want to print them, just follow the article to learn how to print worksheet with comments in two ways. Step 1: Show comments in worksheet you need to print Step 2: Change the overlapping comment position and size Step 3: Choose a way to print comments […]

How to Remove or Change Comment Author Name in Excel 2016/2013/2010

Don’t like the user name set in Excel 2016/2013/2010 for comments? This post is intended to introduce how Excel users could change or remove author name of specified comment, or all new or existing comments. Change author name for one specified comment Change author name for new comments by Excel Options Change/Remove author name of […]

How to Add/Show/Hide Comments to Cell in Excel 2010

In the article, we would find the meanings of comments, and learn how to add and operate the comments to cell in Excel (2010). What a comment can do in Excel? By annotating a worksheet with comments, you can attack additional information to a cell to describe the cell for convenient reading and understanding. For […]

2 Options to Prevent Excel Sheets from Deletion

Is it possible to protect all worksheets or a particular sheet from deletion? If it is, how can you do to restrict any users from deleting excel sheets? Here 2 options in this passage are available for you if you need, which will disable delete sheet option in Excel. Option 1: Protect Workbook structure with […]

3 Methods to Hide or Unhide One or Multiple Sheets in Excel 2016-2007

Do you want to hide sheets for protection or unhide hidden worksheets for visible in Excel 2016/2013/2010/2007? Here 3 effective methods would be talked about in this passage and you can learn how to hide or unhide worksheets in Excel with them. GUI – Graphical User Interface VBA – Visual Basic Application Custom View Method […]

,

3 Ways to Rename Multiple Worksheets Manually or Automatically in Excel

If you have lots of worksheets needed to be renamed now, how will you do? Rename them manually one by one with “Rename” command in Excel or automatically with VBA code or other programs? Just see three ways talked about in this post, you will have your best choice. Way 1: Rename multiple worksheets with […]

Previous Posts Next posts