Free Microsoft Excel 2013 Quick Reference

Making text all CAPS in excel

Is it possible to make all lower-case letters in a given spreadsheet show up
in CAPS? I ask because I am working on a spreadsheet that containers
thousands of cells which have mixed and matched lower and upper-case letters,
and would like to have them all show upper-case for the sake of consistency.

Thank you,
Jon


Perfect. Thanks!

"Jason Morin" wrote:

> Select your data and run this macro:
>
> Sub OnlyUpper()
> Dim cell As Range
> For Each cell In Selection
> If cell.Value = UCase(cell.Value) Then
> cell.Font.ColorIndex = 3 'make font color = red
> End If
> Next
> End Sub
>
> ---
> HTH
> Jason
> Atlanta, GA
>
>
> "Nexan" wrote:
>
> > As part of a macro, I'd like to be able to identify and re-format only cells
> > containing words in all caps. Is that doable?
> >
> > Thanks!

As part of a macro, I'd like to be able to identify and re-format only cells
containing words in all caps. Is that doable?

Thanks!

How to convert text to numbers in Excel

... in another program (such as dBASE or Lotus 1-2-3) or that was downloaded from a mainframe, Microsoft Excel may recognize some numbers as text. This causes functions ...

How to convert text to numbers in Excel 2002 and in Excel 2003

... created in another program (such as dBASE or Lotus 1-2-3) or was downloaded from a mainframe, Microsoft Excel may recognize some numbers as text. This causes functions ...

How to Convert Text to Numbers in Excel

... in another program (such as dBASE or Lotus 1-2-3) or that has been downloaded from a mainframe, Microsoft Excel may recognize some numbers as text. This will cause functions such ...

can auto text be used in excell like it can in word?

How do you make superscripts and subscripts in Excel?

In step 3 of the Text Import Wizard in Excel 2007 (SP1 included), if you
click the «Advanced» button and change the settings, and then click OK, IT
SIMPLY IGNORES YOUR CHANGES. If you click again on the «Advanced» button,
you'll notice the settings are wholly unchanged.
So it's impossible to instruct Excel 2007 to consider dots as decimal
separators, for instance. It will simply ignore it.
Does anyone know if there's a turnaround, or some fix Microsoft has issued,
or anything?

Thanks

TM

The link will setup your newsreader with the Microsoft Newsgroups for the
Excel
group.

I have no idea how to setup a slide show in Excel, but the folks in the Excel
group can help.
news://msnews.microsoft.com/microsoft.public.excel.misc

Or try he
http://www.microsoft.com/communities...&lang=en&cr=US

--
Mary Sauer MSFT MVP
http://office.microsoft.com/
http://msauer.mvps.org/
news://msnews.microsoft.com

"Suleman" > wrote in message
...
> marry what is that news link how i used it
> please help me
>
>
> news://msnews.microsoft.com/microsoft.public.excel.misc
>
>
> --
> Mary Sauer MSFT MVP
> http://office.microsoft.com/
> http://msauer.mvps.org/
> news://msnews.microsoft.com
>
> "Suleman" > wrote in message
> ...
>> Helo everyone
>> I Want To Make a Slide Show In Excel Like Powerpoint
>

Hi,

Any body...please let me know where I can find text Import wizard in excel 2007.

Thanks,
Munawwar Baig

Hello,

Without using any scripting, is there a way to print all worksheets in Excel
with a single click?

I am using Excel 2000.

Thanks

Want to get all colours in Excel 2003 and 2007?
In this format..
Sr.No. ------------- Colour Index No ------------- Actual Colour--------Colour Name

I have just two worksheets ,Excel 2003 and Excel 2007 and the above Column Headings in both the sheets..

I want to get atleast close to 60 Colours if possible.

Regards
e4excel

How do I make hide detail buttons in Excel 2002?

I inherited a file with these and don't understand how to turn them on and
off, adjust them etc.

I am using office 2000. I would like to Change "ALL CAPS" to Just the first
letter of name in caps or "title case" in Excel. I import data from
different sources and I would like to make it all uniform in appearance.
Currently I have to copy date to word, make changes to text case and import
to excel

"WORD" allows you to change the text case. Logic tells me there has to be a
way to do this in Excel.

I am using office 2000. I would like to Change "ALL CAPS" to Just the first
letter of name in caps or "title case" in Excel. I import data from
different sources and I would like to make it all uniform in appearance.
Currently I have to copy date to word, make changes to text case and import
to excel

"WORD" allows you to change the text case. Logic tells me there has to be a
way to do this in Excel.

Is there a way in excel to convert text in a large spreadsheet to all caps in one step by using the range of cells you want to change? I have looked at the UPPER function and can get it to work only on an individual cell. Find and replace workable? Conditional formatting? I'm kind of at a loss...Thanks!

I have several lines of text in one cell in Excel but the text wrap does not
work on all of it. There are just too many instances of needing to use
alt-enter to make it worth doing! Is there a way to get text wrap to actually
work??

Also, why do documents in Excel print differently on different printers or
from different computers? Worksheets look right in print preview but then
come off the printer wrong!

I was wondering if there is a way to link columns, so once the page break is
reached that Excel will automatically continue a list in a designated column
to the right?

I am trying to create a multi-paged checklist of DVD titles. The sheet is
mostly text based, created in Excel 97. The eventual goal is to use this
checklist as a template to catalog all other types of media too (CDs, video
game carts,...).

The spreadsheet is 4 Columns across (A to D) and each page in the
spreadsheet is 30 rows in length. Columns 'A' and 'C' will have check-boxes;
Columns 'B' and 'D' are the DVD Titles (text). I have set the page break to
be every 30 rows (row 31, 61, 91, 121, etc.... )

The problem I am having is trying to find a way to get Excel to
automatically continue text data to the next text column on the same
worksheet page. When both text columns are filled, I would like Excel to
automatically move to the next text column, on following page.

To be a bit more clear--- When I have filled all the 30 rows in column 'B',
for Excel to automatically continue the list in column 'D'. When all 30 rows
of column 'D' (page 1) are filled, I would like Excel to automatically
continue the list on the next page, starting back in column 'B'.

By default, Excel just keeps the list going in one column, making new pages
every 30 rows. That makes for a very long list, especially when it comes to
printing!

I am sure there is probably a very easy solution, but for the life of me,
I'm stumped.

I would grateful for any kind help from forum members. I am still an extreme
noob when it comes to any formulas or VBA coding.

Cheers and thanks in advance,

Shayne T.

I have several lines of text in one cell in Excel but the text wrap does not
work on all of it. There are just too many instances of needing to use
alt-enter to make it worth doing! Is there a way to get text wrap to actually
work??

Also, why do documents in Excel print differently on different printers or
from different computers? Worksheets look right in print preview but then
come off the printer wrong!

Hi,

I have created a rather simple Module which updates TextBox style Labels with values from a seperate Sheet named Engine. It works like a dream in Excel 2003 however when I take it to Excel 2007 it works in some areas however in the most essential one, to update after a particular text box has data in it doesn't.

The code can be viewed below:

Sub UpdateLabels()

Sheets("Main Screen (Beta)").Label10.Caption = Worksheets("Engine").Range("B1").Text
Sheets("Main Screen (Beta)").Label11.Caption = Worksheets("Engine").Range("B2").Text
Sheets("Main Screen (Beta)").Label13.Caption = Worksheets("Engine").Range("C1").Text

End Sub
This module is called Module 4 and I run it at the end of a macro's on the Main Screen (Beta) sheet like so:

Private Sub TextBox1_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer)

If KeyCode = vbKeyTab Then
TextBox2.Activate
With TextBox2
    .SelStart = 0
    .SelLength = Len(.Text)
End With
End If

Module4.UpdateLabels

End Sub
I'm trying to work out if there was a way I could improve the way Module 4 (top) works. Like I say the whole spreadsheet works fine in 2003 however when I try it on a Excel 2007 sheet it only updates Label10 i.e. only runs the top line of the Module.

Is there anything extra I can do to make sure 2007 runs all 3 lines?

Many thanks for your help.

Kind Regards,
Harry Seager

I have an Excel spreadsheet that I am exporting data from SQL server via DTS. the column in SQL is varchar and the column in Excel is text. But after the
export, in Excel the data is stored as "Number Stored at text" instead of text stored as text.

The same thing happens when I use VB to add the data to Excel. here is the VB Code.

For some reason Excel is looking at the contents of the data and if all fields in a colun consist of all
Excel insist on foramtting as the data "number stored as text"

Thanks in advance for help with this problem.

Johnny

Dim mSql As String
Dim mcnn As New ADODB.Connection
Dim mcnnExcel As ADODB.Connection

Set mcnnExcel = New ADODB.Connection
With mcnnExcel

.Provider = "MSDASQL" ' ODBC dsnless connection
.ConnectionString = "Driver={Microsoft Excel Driver (*.xls)};" & _
"DBQ=D:VB_ProjectsExcel1.xls;Extended Properties=Excel 2002 (XP);IMEX=1;FirstRowHasNames=1;MaxScanRows=1;ReadOnly=False;"

.Open
End With

Set mcnn = New ADODB.Connection
With mcnn
.Open "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;PWD=admin;" & _
"Initial Catalog=EXCEL; Data Source=HP-A350Y"
End With

Dim oRS As New ADODB.Recordset
oRS.Open "Select * from [Master Form$]", mcnnExcel, adOpenKeyset, adLockOptimistic

'get recordset from Sql Server
mSql = "select * from texcel;"
meof = fn_810OpenRecordset(mSql, mcnn)

'add the records to Excel
Do While Not (mAdoRs.EOF)
oRS.AddNew
For i = 0 To 4 'these fields need to BE TEXT stored as text
oRS.Fields(i).Value = mAdoRs.Fields(i).Value
Next
For i = 5 To 15 ' these fields need to be numeric
oRS.Fields(i).Value = mAdoRs.Fields(i).Value
Next
oRS.Update
mAdoRs.MoveNext
Loop
--
----------------------------------------------
Posted with NewsLeecher v3.0 Final
* Binary Usenet Leeching Made Easy
* http://www.newsleecher.com/?usenet
----------------------------------------------

Hello everyone,

Looking at Mr. Ron's VBA script examples (http://www.rondebruin.nl), I modified one accordingly for one of my office work.
I am a recruiter for a company and maintain a database of all candidates in excel. Every time a candidate gets accepted or rejected, I have to send him an e-mail of acceptance or rejection. To avoid the repetitive task of manually logging in and typing the text, I thought of making my life easy by working on excel macros.

I would be very thankful if someone may have a look at the spreadsheet I created. I would like you to modify the code a bit if you can spare some time for me in the following manner.

1)I created a list box in column "I" for status. If you select Accept, it sends an acceptance e-mail which is shown in column J along with a time-stamp in column K.
Same thing happens if you select Reject in Status (I column).

The first option in the drop down menu is a BLANK value, incase I do not want to send any emails to particular candidates.

Now what I would is if I add more rows for candidates and want to send an email to only those, how can that be done?
In the current code, it is resending all candidates again.

Is it possible to add a dialogue box which would ask the user :- Would you like to resend "acceptance" or "rejection" email [depending on what you selected in column J] to [persons name] from column A?"

If selected "yes" then resend the email, if selected "no" then do not do anything and proceed to the next row. It would be great to have an additional button of "NO TO ALL" along with "Yes: or "No".

Suppose I had earlier sent emails to 30 candidates and added only a few candidates at the end of the sheet. Now if I only want to send email to those new ones, if we run the code, I do not want to click 30 times on "No" button when I get a pop up which says " Would you like to resend " acceptance" or rejection email to "XYZ" candidate"?

Rather there should be a button of "No to all" by which it sends email only to the newly added candidates and doesnt ask me to resend email to the above already sent candidates.

I would be very thankful if you can help me.

Best regards,

Zain

How to change the case of text in Excel

Describes how to use worksheet functions to modify the case of ... To make these cells lowercase in Excel 2007, follow these ... Note The new column now contains the lowercase version of ...

Hello... I am about to pull my hair out and hope someone can offer some advice (not on the hairpulling, but rather on Excel .
I have roughly 20 simple line graphs in an Excel workbook. I am trying to make them all uniform in format (ie, legend placement, dimensions of graph) without changing the data points in any of the graphs. I tried the method of setting the current format as a user-defined, but applying that changed the actual data points!
Once they are formatted, I am pasting them into Word (as I need page numbering, etc.)

Any advice would be immensely appreciated. These are the LAST touches on a dissertation that has been defended and needs to be put to rest.
Thanks!