Free Microsoft Excel 2013 Quick Reference

How can you restore grid lines?

I am trying to restore the grid lines on a work sheet and can't get them
back. The tools/options/view button is not doing it. Any help?

Post your answer or comment

comments powered by Disqus
I'm trying to create a log-in sheet with titles in the top row and then blank
rows the rest of the page which can be manually filled in. I cannot figure
out how to print the grid lines for the blank rows. Thanks for any

I can only see file, insert, format, and window on my menu bar. How can I


How can you remove all objects in a worksheet at once? graphs etc, if
its possible!

rjmills18's Profile:
View this thread:

You can Customize Shortcut Menus in Word by selecting the Shortcut Menus
check box under Toolbars. But there is no Shortcut Menus check box under
Toolbars in Excel.

So how can you customize a shortcut menu in excel? I have excel 2003, but
excel 2002 had the same lack of functionality.

how can i type multiple lines in a cell...i'm using excel

I need to do the following:

1- Send a message to a newsgroup instead of an email
2- Make a different attachement for each message

ShellExecute 0&
This command ShellExecute 0& will open a new outlook email . How can I change the code to post a message to a newsgroup instead with a name of the newsgroup of xyz

Thank you in advance.

Here is the code for sending an email from excel. how can you change it to make it to send a message to a newsgroup????
================================================== ========================================
Private Declare Function ShellExecute Lib "shell32.dll" _
Alias "ShellExecuteA" (ByVal hwnd As Long, ByVal lpOperation As String, _
ByVal lpFile As String, ByVal lpParameters As String, ByVal lpDirectory As String, _
ByVal nShowCmd As Long) As Long
Sub SendEMail()
Dim Email As String, Subj As String
Dim Msg As String, URL As String
Dim r As Integer, x As Double

For r = 2 To 3 'data in rows 2-4
' Get the email address
Email = Cells(r, 2)

' Message subject
Subj = Cells(r, 1)
' Compose the message
Msg = Cells(r, 3)
' Replace spaces with %20 (hex)
Subj = Application.WorksheetFunction.Substitute(Subj, " ", "%20")
Msg = Application.WorksheetFunction.Substitute(Msg, " ", "%20")

' Replace carriage returns with %0D%0A (hex)
Msg = Application.WorksheetFunction.Substitute(Msg, vbCrLf, "%0D%0A")

' Create the URL
URL = "mailto:" & Email & "?subject=" & Subj & "&body=" & Msg

' Execute the URL (start the email client)
ShellExecute 0&, vbNullString, URL, vbNullString, vbNullString, vbNormalFocus

' Wait two seconds before sending keystrokes
Application.Wait (Now + TimeValue("0:00:02"))
Application.SendKeys "%s"
Next r
End Sub

Private Sub Worksheet_Change(ByVal Target As Range)
Const WS_RANGE As String = "A1" '

How do I eliminate grid lines in an EXCEL Surface chart? I want to create a
contour map but the heavy black close space grid lines make for a very poor

How can you get Excel to sort numbers with alpha suffixes? Example: 1234A
I need to have Excel sort numericaly and not put the numbers with alpha
characters at the bottom but keep them in order like this: 1234 1234A
1234B 1235.
Thanks for any help.

how do you do a line of best fit for a hyperbola?

I wanted to know how can you start up an Excel Spreadsheet with a Formatted
Template instead of the default worksheet which has no formatting assign to
all columns.

Currently, I have created a formatted template and taking the FTP
spreadsheet an successfully cut and pasted the FTP spreadsheet into the
formatted template. I wanted to automate this process to bring up the FTP
Spreadsheet into the formatted template. Is there away I can add commands to
the FTP Spreadsheet to trigger the formatted template to startup?

Please Advise.


How can you remove all objects in a worksheet at once? graphs etc, if its possible!

I would like to know how can i write 2 lines of text in one cell?
i know that if i write a long sentence and wrap the text it will look the same
but there is another way?


Hi team,

Does any one have an idea how can one restore the Data options in the toolbar.

I have run an macro which hidden my Data options.

Please help.


How can you identify duplicate entries in a singe column? Can you identify
duplicate data in 2 columns where each column in on a different worksheet?

I have lost my menu bar - how can I restore it

When VLOOKUP returns a #N/A How can you get it to replace #N/A with a 0

How can you use random numbers without repeating them on a worksheet? The way
it is set up now is, example: =RANDBETWEEN(1,8)
I would like to be able to use the random between but I don't want the
numbers to repeat themselves within the worksheet. Any suggestions or Ideas?

I know from the title of the post that people are going to think this is a standard question about how to turn on grid lines when printing, but it's not.

We had a surge related power outage recently. When the power was restored all of the computers that were running Excel when the lights went out no longer print grid lines. The grid lines are visible when previewing.

The same file on my computer prints the grid lines. ON the other computers no grid lines print. Same file, different computers.

This happened to me once before a long time ago and stayed that way until I upgraded the computer and installed a new copy of Excel.

Can anybody help with this ? We don't want to reinstall all the software.

Thank you.


Column and row lines have broken on my excel document. I'm a new user. How
can I restore column and row breaks?

when drawing a line graph on excel how can you get the gradient on the line

rSomehow users have managed to remove the background grid in an excel
worksheet? Desired (printable) grids are set by borders. Cannot seem to get
these turkeys to use "clear contents" rather than other removal choices
(delete). How can I restore these grids.

I usually can change page breaks by going into page break preview and
clicking & dragging the page brake lines. Today I can't. The cursor is a
cross and it doesn't change to allow dragging of the page break lines. Can
you tell me how to get this feature back?

Hello everybody!

I have a problem. I want to make a graph that looks like the picture from down there. How can i do it. I thought that by moving the grid lines....but is that possible?

Please help me.

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