The PDF format preserves document formatting and protects data from being modified. These features make a PDF an ideal choice when saving completed business documents. When creating a complicated business report or compiling your business tax documents, it’s likely that you’ll quickly accumulate numerous PDF files that require printing. Rather than following the tedious process Read More
Category: Microsoft Office
Create new worksheets based on values in a column
Step 1, download the excel add-on from here. Step 2, Unzip the file. Step 3, Open your spreadsheet on EXCEL. Step 4, Double click “DXL.xlam” to load the add-on. Step 5, Click “DataXL” on the top right and then Click “Ranges“, choose “Split Range into sheets” from the menu. Step 6, Choose how many rows Read More
Split an EXCEL workbook into multiple workbooks by VBA
You may need to split a large workbook to separate Excel files with saving each worksheet of the workbook as an individual Excel file. For example, you can split a workbook into multiple individual Excel files and then deliver each file to different person to handle it. By doing so, you can get certain persons Read More
Change the OneDrive upload or download rate
When you sync files by using the sync app, you can choose how much of your network bandwidth you use. Select the white or blue OneDrive cloud icon in the Windows taskbar notification area. Select More > Settings.(You might need to click the Show hidden icons arrow next to the notification area to see the OneDrive icon.) Select the Network tab. If you’re syncing Read More
Change the font or font size – Outlook
Office 365 (Outlook 2016 | Outlook 2013) – Change the font or font size in the message list To scan through your Inbox more quickly, you may want to enlarge the text in the subject lines and column header or change their font so they’re easier to read. Click Mail Click View > View Settings. Click Other Settings. Read More
How to deal with Replies do not show a picture in the signature
A common reason for this is that you are replying to a Plain Text message and Plain Text messages simply cannot hold any formatting or embedded object such as pictures. Quick workaround A quick workaround is to change the message format from Plain Text to HTML and then to reinsert your signature. Customize Plain Text Read More