QUESTION : Is there any way to keep main file open when doing Save as in excel. When you do […]
Tag: microsoft-excel-2016
Need Auto Increment number beginning with Alphabet in Excel
QUESTION : Suppose I have a number ED000071, I want the next numbers to be ED000072, ED000073, ED000074………ED999999, EE000001. Could […]
Data validation in Excel based on value matrix
QUESTION : I’m really struggeling to solve the following task. I have a data matrix where vehicles and features are […]
How to paste sparse columns so they line up with existing data?
QUESTION : So, I have a spreadsheet with about 5000 rows. Each of these rows has a unique number in […]
Excel – Combining multiple cells in a single row
QUESTION : I have data disposed in this manner: Jonh Seedman New York, New York 01/01/1900 5th Ave +1 NXX-NXX-XXXX […]
Excel condition comparing two cells then fetching data
QUESTION : I’m relearning Microsoft Excel after moving to Numbers a couple years back. I have an idea in mind […]
Excel requires dates to be typed in American format
QUESTION : In order to type a literal date into an Excel cell, I currently have to do it in […]
Change recorded macro to affect current sheet
QUESTION : I have a macro that I use from time to time. It successfully deletes the columns I want […]
excel – activate addin through a Group Policy object
QUESTION : I have an addin that I’m installing on the roaming profile of users. Yet I have to activate […]
Show when column exceeds vertical axis maximum
QUESTION : I’ve built a stacked clustered column in Excel 2016. I’ve manually set the maximum value of the vertical […]