Free Microsoft Excel 2013 Quick Reference

SHOW GRIDLINES ON SPREADSHEETS IN EXCEL?

I'm trying to create a spreadsheet but I can't get the gridlines to show.
How can I get the gridlines to show on all new spreadsheets? Have done the
page setup thing but it only puts lines on where there is type. I want it to
show on the complete page at all times. Thanks


Post your answer or comment

comments powered by Disqus
Hi,
I need to create/access the objects that excel creates when you place a
control on a spreadsheet in excel using the form toolbar. I can't find
a reference to the controls in vba anywhere and the only control
references I have been able to find pertain strictly to "userform1" or
some other variant of a popup form. I need to be able to create a form
directly on the spreadsheet or at least be able to access the controls
I have manually created in excel.
cheers,
-JPN

How do I print titles on every page of a spreadsheet in Excel?

Hello, I've got a spreadsheet that I pass-protected in Excel 2003, but when I tried to open the spreadsheet in Excel 2000 with the same password I get an error saying the password I provided is not correct. What the heck?? Can someone please tell me what I should do -- I don't have Excel 2003 on my home laptop.

Thanks,
10bt

I have a sheet that was sent to me, and it is only showing gridlines on the
left side of the sheet. The box to show gridlines is already checked.

I am experiencing problems after modifying spreadsheets in Excel 2007 (saving
as 2003 compatible .xls format). The files were last sucessfully worked on
in Excel 2003, but may have been created using earlier versions.

PROBLEM: Small files become huge, operations become slow and Excel is pretty
much unworkable.

I have read and tried most of the suggestions in earlier posts, which refer
to checking the last used cell and deleting unused rows and columns and site
information in link: http://www.contextures.on.ca/xlfaqApp.html#Unused.

Although, performing the unused cell deletion, does reduce the file size
marginally (from 6,132KB to 4,432KB), it doesn't solve the problem.

However, if I 'Copy & Paste' the used cell contents and formatting into a
new workbook, this works. File size is reduced to a tiny 146KB.

Does any one have know what could be causing this apparent file corruption,
and a possible fix?

I'm looking for a way to open an OpenOffice spreadsheet in Excel. The
spreadsheet was sent from one of my suppliers so I'm unable to ask her to
convert it to Excel. My IT manager has locked down the machine so I can't
install OO on it.

Are there any converters for the OpenOffice file? I recall reading that the
file format is an official international standard, so I'm guessing that
Microsoft must have written a converter for it.

Many Thanks

I have 2 spreadsheets in Excel 2003. Spreadsheet A has links to data in
spreadsheet B. If spreadsheet B is closed when I open Spreadheet A, I am
asked if the links should be updated. If Spreadsheet B is open when I open
spreadheet A, I am not asked if the links should be updated.

Why am I only asked if updates should be made if the linked to spreadheet is
closed?

Thanks in advance for clearing up that which is cloudy for me.
Have a great day.

Hello, I have a question about Excel 97.
When I used to open multiple workbooks, I would get a seperate icon on the
taskbar that I could click on for each workbook. (I could also Alt-Tab to
each workbook.)
I just re-installed everything on a new computer system and now the only way
to switch between multiple workbooks is to click on "Window" in Excel and
then click on the workbook I want to use.
Two things that will NOT work a
-Going to Taskbar and Start Menu. Clicking "Group Similar Taskbar
Buttons"
-In Excel going to Tool, options, view, checking "Windows in Taskbar".
(Excel 97 does not have this item, it only came in Excel 2000 or later)
How do I go back to my "old, but good" system?
Thanks, Sean.

Is there any way to link spreadsheets in Excel, so that a value entered in
Sheet 1 is automatically transferred to Sheet 2?

Hello,

I have created a spreadsheet in excel with client data and situation/recommendations. What I do is go into excel enter the data. My spreadsheet then has all the calculations and charts for me.

Now, I want to create a document/template/process which will take this info and populate predetermined reports in word.

For example, I would like to have to reports 1. Custom report single, 2. Custom Report Married, 3. Custom Report Married with Children.

If I choose Custom Report Married, then that report (that I have previously designed will popular my client's info aswell as their situation/recommendations.

Can anyone help me with this please??

how to paste a picture into the header of spreadsheet in Excel 2000

Hello, I have a question about Excel 97.
When I used to open multiple workbooks, I would get a seperate icon on the
taskbar that I could click on for each workbook. (I could also Alt-Tab to
each workbook.)
I just re-installed everything on a new computer system and now the only way
to switch between multiple workbooks is to click on "Window" in Excel and
then click on the workbook I want to use.
Two things that will NOT work are:
-Going to Taskbar and Start Menu. Clicking "Group Similar Taskbar
Buttons"
-In Excel going to Tool, options, view, checking "Windows in Taskbar".
(Excel 97 does not have this item, it only came in Excel 2000 or later)
How do I go back to my "old, but good" system?
Thanks, Sean.

We have created a spreadsheet in Excel 2000 with cells that use a list of values (drop down menu). The cells are then locked and the sheet protected to force users to select only from the list of values. This works ok in 2000 however when we open the spreadsheet in 2003, the sheet throws an error saying the cell is protected and thus read only and do not allow the user to select from the list of values. There seems to be a different interpretation of locking/protection between Excel 2000 and Ecel 2003.

How can we protect these cells in 2003 to force users to only select from the list of values (we do not want anyone to be able to type anything in freetext.

Any advice much appreciated.

cheers
sal

Is it possible to use conditional formatting on text in Excel? For instance make the cell color of all cells with the text of "Yes" red. Please provide a quick overview or link to help.

Thanks.

I tried to format a new spreadsheet to print gridlines on all cells with page
setup. When I then click on Print Preview, gridlines do not show.

I tried to format a new spreadsheet to print gridlines on all cells with page
setup. When I then click on Print Preview, gridlines do not show.

Hi!

If I want to show several pictures/images in Excel, were every picture/image is based on different cell (one macro for each picture), how will the VBE code be?

Example; If I have a list of several job positions and a list of several people to fill into these positions, and when I chose Person 1 in position 1, a picture of person one should show, when I chose Person 2 in position 2, a picture of person two should show, etc.. So then the sheet would show all the people in the different positions... Is this possible to do?

Hope someone could help me on this..
PS; I am not a programmer so you most likely have to explain it to me on a basic level..

Thanks!!

Morning all,

I have created a spreadsheet in Excel 2007 that works just fine. However, when run using Excel 2003 the code fails in a couple of places. My original code is:


	VB:
	
 Export() 
     '
     ' Export Macro
     '
     ' Keyboard Shortcut: Ctrl+x
     '
    Sheets("Menu").Select 
    Sheets("Menu").Copy 
    ActiveSheet.ChartObjects("chtSales").Activate 
    ActiveChart.PlotArea.Select 
    ActiveSheet.ChartObjects("chtSales").Activate 
    ActiveChart.ChartArea.Select 
    ActiveSheet.ChartObjects("chtSales").Activate 
    ActiveChart.Location Where:=xlLocationAsNewSheet, Name:="Sales Monthly" 
     'ActiveChart.SetElement (msoElementDataTableWithLegendKeys)
     'ActiveChart.SetElement (msoElementChartTitleAboveChart)
     'ActiveChart.ChartTitle.Text = Sheets("Menu").Range("H6").Value
     'ActiveChart.ChartArea.Select
    Sheets("Menu").Select 
    ActiveSheet.ChartObjects("chtDaily").Activate 
    ActiveSheet.ChartObjects("chtDaily").Activate 
    ActiveChart.Location Where:=xlLocationAsNewSheet, Name:="Sales Daily" 
     'ActiveChart.SetElement (msoElementDataTableWithLegendKeys)
     'ActiveChart.SetElement (msoElementChartTitleAboveChart)
     'ActiveChart.ChartTitle.Caption = Sheets("Menu").Range("Q6").Value
     'ActiveChart.ChartArea.Select
    Sheets("Menu").Select 
    ActiveSheet.ChartObjects("chtStock").Activate 
    ActiveSheet.ChartObjects("chtStock").Activate 
    ActiveChart.Location Where:=xlLocationAsNewSheet, Name:="Stock" 
     'ActiveChart.SetElement (msoElementDataTableWithLegendKeys)
     'ActiveChart.SetElement (msoElementChartTitleAboveChart)
     'ActiveChart.ChartTitle.Caption = Sheets("Menu").Range("H28").Value
     'ActiveChart.ChartArea.Select
    Sheets("Menu").Select 
    Range("O30:U40").Select 
    Selection.Clear 
    Sheets("Menu").Select 
    ActiveWindow.SelectedSheets.Visible = False 
    Sheets("Sales Monthly").Select 
End Sub 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines
The code falls down with the .SetElement method. Additionally on the line:


	VB:
	
ActiveChart.ChartTitle.Text = Sheets("Menu").Range("H6").Value 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines
I get run-time error '1004': unable to set the Text property of the Chart Title class.

What I need is for each chart to show its data table and for the chart title to pull it's data from the 'Menu' worksheet's relevant cells - and obviously be compatible in both Excel 2003 and Excel 2007.

Any help greatly appreciated, as always.

RDF

I just started having a strange issue in Excel 2007. No other users on my
network have this issue.

I am trying to get data from other sources. My steps are as follows:
1) Click "Data" tab
2) "From Other Sources"
3) "From Microsoft Query"
4) Click "MS Access Database" and hit OK
5) Click on drop down for "DRIVES".

Here's the issue. I cannot see any of my mapped network drives. They show
mapped in Windows Explorer and I can connect and browse them just fine. I
rebooted, logon script runs fine, drives mapped fine, but Excel doesn't seem
to see them.

Any thoughts?

Using Microsoft Windows XP (including updates) and Excel in Office 2003. When
requiring background colour for cell and/or colour for type in cell, I can
set it using either the "format" tab or the format keys in the toolbar and in
both cases when I do this and print the result all is fine, however, the
problem is no indication of the colours chosen is shown at any time on screen
(as used ok in Windows 98 and as seen on other users XP. Please advise what
to set, unset, or both as required to achieve my aim. Many thanks. Jim

At work we use excel 1997- 2003 Excel spreadsheets .If I want to work on
these at home I can't get the macros working in Excel 2007 . Can someone
please help

I have several charts that are displayed as their on worksheets in excel 03
but don't show up in excel 07 how can i fix it so that these charts will
display?

I am working with a database created in Excel. Included in that database is
a series of hyperlinks to pictures saved on a shared drive on network. When
the spreadsheet is run from a local computer the hyperlinks work fine, but
when it is saved on the network, the hyperlinks become truncated at the
begining, instead of:

k:folderafolderbfoldercpicture.jpg

I get:

.......foldercpicture.jpg

This happens on saving the spreadsheet on the network...

We cannot get gridlines to print in Excel 2007. We have the checkbox checked
on the print gridlines under page layout. We also have gridlines checked on
the view tab.

Any thoughts?


No luck finding an answer? You could always try Google.