QUESTION : I have C1 that needs to combine C2 and C3. The problem with this is that is that […]
Tag: cells
Excel – Mirror Specific Cell Range
QUESTION : Is it possible to mirror or replicate a cell range from one worksheet to another? For example: ———————————————- […]
How do I create a summary of the same few cells on many different sheets in Excel 2013?
QUESTION : I have an Excel workbook with 140 sheets. I’m trying to summarize the same 3 cells in each […]
How to shift cells to the left without affecting its “own column” in Excel (i.e. via VBA)?
QUESTION : COLS : NO | | B | C | | D 01 : 1 | | 8 | […]
Call on a cell in Excel up to the first semi-colon
QUESTION : I am using the =CONCATENATE function, and one of the cells I’m calling on I only want to […]
Excel changes typed formula
QUESTION : Why does excel change cell entrys Example: Initial entry +20+20 Next time I click on cell the contents […]
Excel merge cells, keep values, collapsing chart
QUESTION : Imagine a chart that looks like this (rows 1,2,3 are merged in columns B,C,D): A B C D […]
Changing from an excel spreadsheet to another always going to same cell ref
QUESTION : can anyone help with hint of how to move from an excel spreadsheet by selecting another tab, and […]
Excel vba code for adding a value to existing cell of sheet
QUESTION : I have this code to add value of a cell to an existing value of the other cell: […]
VBA to check if all cells in a range are empty before proceeding further
QUESTION : I would like to apply a check before executing next lines of code. I wrote a simple structure […]