Microsoft has been purposely breaking things in their past softwares in order to force upgrades to their spyware programs such as Office365 & Windows10. For Example, in Office 2016 Professional Plus, You cannot ctrl+click to desselect a cell. This was a feature that has always been apart of Excel. They disabled it in 2016, making … Continue reading Microsoft’s Dark Agenda for Office, OneDrive, & Windows 10
In the Screenshot above, this Pie Chart will adjust automatically to new values added into the Excel Sheet, adding or removing new categories as values are entered or deleted. I have something like around 80 different Categories, but each day perhaps only 10 or so get used, but they could be any 10 of the … Continue reading Create a Dynamic Pie Chart with Dynamic Legend in Excel which Doesn’t Display Zero Amount Categories, and Adds or Removes Categories & Updates Dynamically with the Entered Data
In the screenshot above, when a value is entered under the time slots on the right (causing them to change format to a Deep Red Fill with Bold White Font), the Activity in the far Left Column darkens a shade and turns the font bold to let me easily review the activities which have been … Continue reading How to Conditionally Format a Cell Based on the Presence or Absence of Data in a Range of Other Cells
There's no need to spend 400-600 dollars on getting your spreadsheet converted to a form and published on a webpage. In the example above, the first numerical field, "4.25", is the only editable Field. Create your Form the way you want it to look Go to View > Page Break View > & set it … Continue reading How to Convert an Existing Excel Sheet into a Quick Form with a Few Select Fields with Background Calculations in Excel
Here is an Excel Formula for creating an Excel Form which will apply separate Math Formulas depending on the input, and if no input is entered a default text will be displayed requesting input. In this case, we'll apply one mathematical formula if the form is filled out by a Male, and a Separate mathematical … Continue reading IF-THEN & IF-ISBLANK Excel Formulas for Switching Between Different Mathematical Equations Based on Different Inputs, if Present
Sometimes you keep opening a sheet that you have on your computer and every time it opens it launches in Protected View. If you've tried going to File > Options > Trust Center > Trust Center Settings > Protected View > and disabling everything, you shouldn't. Make sure those all say "Enabled" for security, otherwise … Continue reading Disabling Protected View in Excel Sheets for Trusted Documents Only – Office16
instead of: game 10 game 2 game 24 game 3 Use ASAP Utilities Tab "Range" icon Select "Advanced Sorting" from the menu Sort By: "Alphanumeric Content" Then By: "Value" to get: game 2 game 3 game 10 game 24
use the following formula to combine data from two columns into one =A2&C2&E2 enter this formula into a new column, copy the column, and "Paste Special" with "Values" only and use this formula to keep a space between items which you are combining =A2&" "&C2&" "&E2
Data Tab Highlight column with email addresses click on Filter Click on drop-down box which appears at top of column go to "Text Filters" Click on "Custom Filter" in the first box, click "Does Not Contain" type in "@" in the right box in the bottom box select "Does Not Contain" type a "." select … Continue reading Validating Emails in Excel
This the best thing I've found for Office Download the Free Home version of ASAP Utilities here ASAP Utilities Close Excel Install, there will be a new tab called "ASAP Utilities"
If importing excel lists into outlook tells you no values are named so it wont import: Open Excel click on the column which contains the data you want to input be sure the first row contains the data name, like "Email 1", on the first top row Select from the top down to the bottom … Continue reading Import Contacts to Outlook Fail from Excel
Open PDf in Acrobat Pro Go to Menu Bar > View > Page Display > Continuous (Single or two-page) Ctrl+A to Select All, or select only the information from the PDF you want Method 1: Right-Click, and select "Copy as Table" Open Microsoft Excel, click in cell A1, and hit Ctrl+V to paste Method 2: … Continue reading Convert Information in a PDF document to an Excel Table
To convert cells with month numbers such as 1, 2, 3, 4, etc, use the following formulas: =TEXT(DATE(2000,A1,1),"mmmm") for Full Month Name (January, February, March, April) =TEXT(DATE(2000,A1,1),"mmm") for 3-letter Month Abbreviation (Jan, Feb, Mar, Apr) =TEXT(DATE(2000,A1,1),"mmmmm") for 1st letter of Month (J, F, M, A) Paste the formula in a blank cell to the side … Continue reading Convert Numbers into Month Names in Excel
Select the Column with the rows you want to delete Press F5 Click "Special..." Select "Blanks" Click "OK" Then click on "Delete Cells...'
Load XML db File into Dreamweaver, and make it editable Copy & Paste entire XML code & text into a new Word doc Use Find & Replace to rename all categories & database elements to your own database names, for example: Find: QYPWMC=, Replace: Category Name: Find: z=, Replace: Category Name: etc Be sure to … Continue reading Convert an XML Database to Excel or Access DB
Sadly, there's no internal way to do this within Excel, as its own clipboard can't handle large sizes and will truncate a good part of it. So here are my methods Option 1: In Excel, go to: Page Layout > Print Area. Set the Print area all for your entire table you want to export, … Continue reading Saving Very Large Excel Documents to Images