autoformat

I have formatted the cells in a database I built in Excel 2013. The problem is, I need other people to copy rows and redirect the hyperlink on the new row to a new page. But when you add a hyperlink Excel "helpfully" undoes the formatting I've inserted. I know I can change the default...

I work with some software that generates various reports as excel docs. The naming convention is always the same for these documents. There are a total of 4 documents I draw from to make a final report. Most of the numbers on this final report are simple cut and paste from one workbook into...

Hi, I'm writing a macro in Microsoft Word 2010. The macro itself is inserting and deleting bookmarks based on user inputs in an excel document. There is one table in this document that is 6 pages long and I adjusted the orientation to Landscape for these pages only. The rest of this document...

Basically whenever I enter " (quotation 1 symbol) and follow it by a Cyrillic text, Excel automatically changes it to two apostrophes ('' 2 symbols) and my formulas start trowing up errors. It also happens when I edit only the text of a previously working formula, as demonstrated in this short...

How do you restore the default color (black) for PivotTables created through the Wizard? Current PivotTables default to red borders instead of black. The borders may be manually changed to another color but return to red when the data is refreshed. Please help!

Problem: I have a few contiguous cells (below each other in same column) that are shaded (fill color). When I enter text/data/whatever in the next cell down and hit [ENTER], the cell I just entered text/data/whatever into automatically shades to the same color as the few cells above. I want to...