Tagged Questions
0
votes
1answer
26 views
Having trouble creating certain graph in Excel
I want to create a graph which given a list of dates, will produce a line graph representing the number of occurrences of list dates. For example, this would be ideal.
But when I try to recreate ...
-4
votes
2answers
44 views
file extension not valid . when it is
I can't open a excel file on my home computer. Every other computer I use opens the file apart from this one I use at home .
I get a error message -
financial.xlsx format is not valid.
This is ...
-3
votes
0answers
39 views
In Excel 2007, why must I click the title bar of an open spreadsheet to bring it to the front? [closed]
I'm using Excel 2007, and when there's a spreadsheet window behind another spreadsheet window that I want to bring in front, I can click the side of the covered window, but it doesn't bring it in ...
17
votes
5answers
543 views
How to simultaneously rename a file in MS Office and delete old version?
In Microsoft Office, when wanting to save a file to a different file name without keeping a copy of the previous file name, doing so requires two steps:
First, File -> Save As... and select the new ...
0
votes
0answers
21 views
Is it possible to use alt-XYZ shortcuts on Excel on OS X?
I don't want to know the equivalents -- I want to use the same commands. I'm switching between windows at work and a mac at home.
0
votes
2answers
153 views
How to open xlsx files with Excel 2013 by default on windows 8?
My xslx files open systematically with Excel 2010 when I'd like them to use Excel 2013.
Everytime I
right click
select open with
point to C:\Program Files\Microsoft Office ...
0
votes
1answer
15 views
Excel/Calc: Pivot table with (almost) identical row: how to identify them?
I need to examine via pivot a datasource from a sheet. This datasource sheet is something like this:
| Field 1 | Field 1 | Field 3 |
| AAAA | BBBB | CCCC |
| DDDD | EEEE | FFFF |
| GGGG ...
2
votes
1answer
73 views
How to config Microsoft Office Application (Word / Excel) to stop adding personal information to the document?
I have created word document (*.doc or .docx) or excel documents (.xls or *.xlsx).
Sometime, these documents need to be sent to some customer and therefore require personal information to be removed ...
-4
votes
1answer
46 views
Importing data from, to and between sheets in Excel
I have a cell in sheet 1 (temperature value) and in order to get its corresponding kinematic viscosity value in another cell in sheet 1, I have to choose from a range of cells (in tabular format) in ...
0
votes
1answer
54 views
How to do cell coloring back and forth automatically in Excel
I'd like to ask on how to do a cell coloring for the following case:
For example, I have an excel like this:
Col1 Col2
A 1
A 2
B 3
B 4
B 5
C 1
C 2
D 1
D 2
E 2
E 8
E ...
2
votes
2answers
72 views
How do I stop Excel from checking the validity of hyperlinks before it opens them?
If you open an Excel spreadsheet containing external hyperlinks, when you click the link, Excel will check that the link is valid (i.e. doesn't return a 404 error) before actually opening it in the ...
0
votes
1answer
158 views
How to extract numerical value after a certain string within a sentence in Excel cell?
I want to extract the numerical value immediately following the string "ABS" (Case sensitive) within a bulk of text in a cell from an Excel table.
Not all the cell may contain the the string I'm ...
0
votes
0answers
40 views
Excel creating weird diagrams
I have a list of times in one column. They are formatted as Time cells. When I simply select the values and click Insert -> Line (diagram), I can't seem to get the right kind of diagram.
What ...
2
votes
2answers
74 views
Need formula from excel to get the text (organisation name) from the email id
I need a formula in excel with if condition.
if the mail id abcd@xyz.com then the result should come as XYZ, if the mail id is abcd@.in.xyz.com then the result should come as XYZ.
result should be ...
0
votes
2answers
196 views
How to Split one column in Excel into multiple columns of 55 rows
I have a movie list with over 1500 entries (A1-A1500), all alphabetized (Thanks to Excel) and I would like to split that into multiple columns of 55 rows each on a separate sheet if possible. So ...
0
votes
1answer
85 views
Excel: Accept only unique values in coloumn
In Microsoft Excel, I want to filter entries so that only unique domain names appear. Suppose I have 10 records:
1. www.manish.com
2. joo.mj.com
3. ko.kiop.eu
4. mail.manish.com
5. ...
0
votes
2answers
96 views
If / Else logic involving text i Excel
I want to perform the following logic in a Microsoft Excel 2010 worksheet:
In cell E3: if C3 = Off or off then VALUE=0, else Value=C3*D3
Where cell C3 will contain either a number or the word 'off' ...
3
votes
3answers
911 views
How to insert empty rows in Excel 2013 when I have copied rows in my clipboard?
This seems like something which should be painfully simple to do but I can't figure it out. So with an empty clipboard I can right click on a row header and say insert row, no problem, it inserts a ...
0
votes
2answers
605 views
Excel 2010 Macro - Copy cell range with formulas and paste values only
I want to create a simple macro that will copy a range of cells with information generated by formulas on sheet 2, to a range of cells on sheet one. I need to paste only VALUES on page 1, leaving the ...
1
vote
0answers
100 views
Excel/Word on MAC - includepicture containing url
I have the following:
A excel spreadsheet with names and url's to a QR code, each in a column of the spreadsheet. The url returns a jpeg picture of the QR code.
A word doc where these names and ...
0
votes
1answer
66 views
Adding Subsequent Cell Values For Each Row in Excel
I'm new to excel so this might be a simple question. I have around 100 rows with 7 columns. Out of those, 4 column needs to have the value computed by 3rd and 2nd columns' value of the same row.
I ...
1
vote
1answer
47 views
Make a cell resize and fill contents into a cell when data is on separate lines
I have addresses in a text file, and they're all on different lines (see 1st Image).
When I copy and paste this data to an excel file, they all appear on different lines, not matter how much I try to ...
2
votes
2answers
103 views
Excel 2007 Images Embedded In Comments = File Too Large
I made a list of all the major electronics (pc towers, laptops, monitors, etc) at my workplace for inventory. To make it better I wanted to add pictures so I could see what each of the items looked ...
0
votes
2answers
45 views
Excel files are opening with PowerPoint instead
When I first used a flash drive containing Excel files, Microsoft Excel was not installed on my computer.
So, Windows 7 opened it with PowerPoint and now all the Excel files on my flash drive open ...
1
vote
0answers
228 views
Is it possible to add a data connection to an existing table in Excel?
I have a table in Excel which has a data connection to an Access database. When the data changes, I can click "Refresh" to re-query the data and update the table.
However, Excel 2008 for Mac doesn't ...
0
votes
0answers
42 views
Fill in Text Values in Excel for Mac Without Dragging
I'm using Excel 2008 on a Mac. I need to insert a blank column as the first column and in between pre-existing columns. I want to place some text in each column in the first row with data and then ...
1
vote
3answers
1k views
How to change or remove all traces of original author name in Excel 2010 document
At our company we need to deploy one Excel Workbook in that way that nobody would see it is made by us by looking at the Office metadata.
What fields do we need to look for? I know, that the document ...
0
votes
2answers
41 views
Deleting specific text in several columns in an Excel spreadsheet?
I have several columns with several cells. Some of them contain the letter "R". I want to change all cells across all columns that contain the word "R" to be replaced with a blank. Normally I would ...
0
votes
1answer
175 views
Adding a “Printed by”-watermark in Excel
Google couldn't help me, but I know the participants in Super User sometimes have more knowledge then what is publicly available, so to my question: Is there any easy way to add a watermark to an ...
1
vote
1answer
84 views
Excel cut-n-paste behaviour
I am using spreadsheets to quickly sort the garbled tables. For example, I have an address sheet with columns for region, city (republic, zipcode, address, etc.). Some cities are erroneously in the ...
0
votes
0answers
326 views
Changing default file type used by windows explorer
We currently use Microsoft Office 2010
I've just downloaded the beta version of Office 2013 to play with (mainly to look at Power View for xl)
After the install in Windows explorer all the xl file ...
1
vote
2answers
212 views
Why does Excel try to open password-protected URL links itself instead of just giving to the browser?
I have links to secure sites inside Excel spreadsheets (currently 2010, but I'm pretty sure it's the same with Office 2007).
When I click on them, instead of just launching the system browser ...
3
votes
1answer
173 views
Stop Excel from changing file contents upon open
I use synchronization a lot on my machines. Excel changes the modification date right at the very moment it opens the file. Then, it changes the contents of the file (I guess to update the statistics ...
2
votes
2answers
90 views
Skip rows in excel
I'm doing a budgeting spreadsheet in excel. Along the top, the columns are headed for each budget item I need to account for. The rows are each labelled with dates on a daily basis. At the end of each ...
3
votes
1answer
145 views
Automatic LaTex document generation from Excel spreadsheet
I have some data in an Excel file from which I have to generate a report. I repeat this task fairly regularly and am looking to automate it. I have a LaTeX project into which I usually just copy data ...
1
vote
1answer
144 views
Why do Microsoft Office Excel and Word not know how to open files?
I have Windows Vista and Office 2007.
Whenever I click on a document such as an Excel or Word document I get this error.
It's annoying as I have to wait for the application to load, get the error ...
1
vote
1answer
31 views
Adding additional user info into Microsoft Office templates
Is there a way to add additional user address, email, phone information into MS Word and Excel for use with mail Merge or Form fill templates?
MS Word show user, user initials, and useraddress as ...
1
vote
1answer
257 views
Excel for Mac - unable to create my own macros
I have a macro (made for Excel - Windows), which url encode strings - i.e. space becomes %20.
When I open the *.xlsm on a Mac with Excel installed(Office for Mac 2011), it does not work.
No errors - ...
2
votes
1answer
104 views
Custom area graph in Excel (or google spreadsheet)
I am trying to visualize my loans with area graph and have some additional needs/wishes.
For example - this is my data (made up):
house car mower vacation
diners ...
2
votes
1answer
558 views
Word 2010 - Mail Merge with Superscript Formatting
I have a user with a letter in Word 2010, built for a mail merge. The source document for the addresses is another Word document. The source document includes addresses that have super-scripted ...
0
votes
1answer
154 views
data safety in excel
If protecting workbook in ms excel (2010, 2007, 2003) is enough safe for a sensitive data?
There is a possibility to choose encryption aes 128 bit in ms excel 2003 and 2007 (as default), from that ...
1
vote
2answers
1k views
Excel 2010 Pivot Table: How can I expand/collapse a subset of records beneath a distinct set of records?
Consider the following set of data in a table called Employee:
Name Sup Q1Sales Q2Sales Q1Atte Q2Atte
John Joe Good Bad Bad Bad
Mary Joe Good Bad Bad Bad
Bob ...
2
votes
2answers
184 views
Languages of Microsoft Office
I am in France, and I just bought the CD Microsoft Excel 2010.
While installing it, there was no option to choose the language. After the installation, the language is in French which matches the ...
1
vote
1answer
87 views
Small utility to edit excel files
I want to edit my excel file. I don't have Microsoft Office installed. The files include xls and xlsx. I would like to know about the smallest utility available to download. It should not be online ...
2
votes
2answers
3k views
How do I bring back the ribbon in Office 2010?
The ribbon in Excel 2010 appears when I click on Home or Insert or one of the other tabs, but disappears again when I go back to editing my document. I'd like it to always be visible - how can I get ...
0
votes
1answer
269 views
Did Lion eat Excel
I'm running on OSX 10.7.3 using Microsoft Office 2008 (with the latest updates).
Recently, Excel started crashing on startup. It happens so fast it is hard for me to detect what's going on but ...
-3
votes
1answer
667 views
.tar file to excel conversion [closed]
Hi i was requested to convert a file by one of my client.I need to convert a .tar file to a ms excel. I gave the below steps to them but some of the fields in the content are missing. Please suggest ...
1
vote
3answers
315 views
Compare Spreadsheet to Database to Generate Document
I am trying to streamline the production of a document that has to be created on a regular basis. There are tasks associated with detailed instructions on how to complete them, and each of these has ...
0
votes
2answers
377 views
How to set the displayed precision for a complex number in Excel 2010?
MS Excel provides a set of functions to work with complex numbers. When displaying real numbers, one can set the decimal places precision from the Format Cells dialog. However, it does not work for ...
1
vote
3answers
3k views
Microsoft-excel newlines and tab
Current I use "CONCATENATE" to join string in Excel, but I want insert character newlines and tab in string joined by "CONCATENATE".
Example:
I've string below when I completed join string.
"Today ...
