A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Search Forums
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Showing results 1 to 25 of 100
Search took 25.06 seconds.
Search: Posts made by: Gord Dibben
Forum: Setting up and Configuration June 7th, 2010, 09:32 PM Posted to microsoft.public.excel.setup
Replies: 1
Views: 2,644
Posted By Gord Dibben
how to delete excel task pane

ToolsOptionsView.

Uncheck "Show Taskpane"


Gord Dibben MS Excel MVP

On Mon, 7 Jun 2010 12:56:58 -0700, Paul
wrote:
Forum: General Discussion June 6th, 2010, 05:02 PM Posted to microsoft.public.excel.misc
Replies: 4
Views: 1,060
Posted By Gord Dibben
Formula

=IF(B1="",A1/60,IF(B10,B1/60,"B1 is =0"))


Gord Dibben MS Excel MVP

On Sun, 6 Jun 2010 08:36:31 -0700, Trainee
wrote:

I'm in need of a formula in C1 that...
Forum: General Discussion June 6th, 2010, 04:47 PM Posted to microsoft.public.excel.misc
Replies: 1
Views: 896
Posted By Gord Dibben
Excel 2010

See one reply at your first posting.


Gord Dibben MS Excel MVP

On Sun, 6 Jun 2010 08:04:38 -0700, ComputerLady143
wrote:

I have installed Excell 2010...
Forum: Worksheet Functions June 6th, 2010, 04:30 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 4
Views: 3,219
Posted By Gord Dibben
Select a worksheet

Private Sub Worksheet_Calculate()
On Error GoTo stoppit
Application.EnableEvents = False
With Me.Range("A1")
If .Value = "Desktop" Then
Sheets("Desktop").Select
...
Forum: Setting up and Configuration June 6th, 2010, 04:13 PM Posted to microsoft.public.excel.setup
Replies: 1
Views: 2,364
Posted By Gord Dibben
Excel 2010m - Files

I don't use 2010 but all earlier versions would open every file in XLSTART
folder or Alternate startup folder.

Delete any path to Alternate startup folder and/or remove all files from
XLSTART...
Forum: General Discussion June 5th, 2010, 04:18 PM Posted to microsoft.public.excel.misc
Replies: 2
Views: 421
Posted By Gord Dibben
can't "undo" to original document

If running version 2007, saving does not clear the undo stack so you should
be able to undo your changes.

Earlier versions do clear the stack so no reversal is available.


Gord Dibben MS Excel...
Forum: Setting up and Configuration June 5th, 2010, 04:11 PM Posted to microsoft.public.excel.setup
Replies: 1
Views: 2,418
Posted By Gord Dibben
view Excel row & col headings in a large font size e.g. Arila 20 p

2007 ButtonExcel OptionsWhen creating new workbooks.

Make you settings here and all new workbooks will be that default.

Will not affect existing workbooks.

For existing workbooks you will have...
Forum: General Discussion June 5th, 2010, 03:32 PM Posted to microsoft.public.excel.misc
Replies: 1
Views: 490
Posted By Gord Dibben
Navigation buttons in Excel 2007

Sheet navigation buttons work same in 2007 as previous versions.

Clicking on the buttons does not select a particular sheet, just scrolls the
sheet tabs.


Gord Dibben MS Excel MVP

On Fri, 4 Jun...
Forum: Worksheet Functions June 5th, 2010, 01:27 AM Posted to microsoft.public.excel.worksheet.functions
Replies: 1
Views: 452
Posted By Gord Dibben
Keeping Formulas Not Data

You don't need data in order to have formulas.

What is the real question here?

Do you want the cells with formulas to look blank until data is entered?

I suggest you trap for no data.

In B1 enter...
Forum: Worksheet Functions June 5th, 2010, 01:23 AM Posted to microsoft.public.excel.worksheet.functions
Replies: 2
Views: 401
Posted By Gord Dibben
F4 no longer automatically creates absolute reference

Do you have an F-Lock keyboard?

Change state and see if F4 is enabled.


Gord Dibben MS Excel MVP

On Fri, 4 Jun 2010 12:46:18 -0700, molla
wrote:
Forum: General Discussion June 5th, 2010, 01:10 AM Posted to microsoft.public.excel.misc
Replies: 3
Views: 427
Posted By Gord Dibben
Move rows into columns

Assuming column A with consistent sets of data........six cells to a set.

In B1 enter =INDEX($A:$A,(ROWS($1:1)-1)*6+COLUMNS($A:B)-1)

Copy across to G1

Select B1:G1 and copy down until you get...
Forum: General Discussion June 5th, 2010, 12:47 AM Posted to microsoft.public.excel.misc
Replies: 4
Views: 625
Posted By Gord Dibben
Pick list width

Beats me too.

Did you find anything helpful at Debra's site?


Gord

On Fri, 4 Jun 2010 05:32:40 -0700, Joe M.
wrote:
Forum: General Discussion June 5th, 2010, 12:43 AM Posted to microsoft.public.excel.misc
Replies: 2
Views: 436
Posted By Gord Dibben
Macro Message Bar

If the workbooks that don't display the disabled with notification message
bar have been placed in a "Trusted Location" the disabled with notification
will be overridden.

Macros will be...
Forum: General Discussion June 4th, 2010, 11:56 PM Posted to microsoft.public.excel.misc
Replies: 3
Views: 467
Posted By Gord Dibben
DROP DOWN LIST

In a general module in the workbook place the Browse_Sheets macro.

In Thisworkbook module place this event code.

Private Sub Workbook_Open()
Browse_Sheets
End Sub


Sub Browse_Sheets()
Forum: General Discussion June 4th, 2010, 11:51 PM Posted to microsoft.public.excel.misc
Replies: 3
Views: 470
Posted By Gord Dibben
How to set the default format on excel?

Open a new workbook and customize/format each sheet as you wish.

FileSave As Type: scroll down to Excel Template(*.XLT) and select. Name
your workbook "BOOK"(no quotes). Excel will add the .XLT...
Forum: General Discussion June 4th, 2010, 01:42 AM Posted to microsoft.public.excel.misc
Replies: 8
Views: 524
Posted By Gord Dibben
Coloring cells

Yes. Has worked since version 8 which is Excel 97


Gord

On Thu, 3 Jun 2010 20:24:16 -0400, "OldManEd" wrote:

Does this work in both Excel 2003 and Excel 2007?
OldEd
Forum: General Discussion June 4th, 2010, 01:01 AM Posted to microsoft.public.excel.misc
Replies: 8
Views: 524
Posted By Gord Dibben
Coloring cells

You just need Conditional Formatting.

See help on that subject.


Gord Dibben MS Excel MVP

On Thu, 3 Jun 2010 19:12:27 -0400, "OldManEd" wrote:

I have a column of numbers....
Forum: General Discussion June 4th, 2010, 12:29 AM Posted to microsoft.public.excel.misc
Replies: 2
Views: 458
Posted By Gord Dibben
Increment Value By 1 Each Time Spreadsheet is Opened

This workbook will be a true Template(*.xlt)?

For sequencing numbers see John McGimpsey's site.

http://www.mcgimpsey.com/excel/udfs/sequentialnums.html


Gord Dibben MS Excel MVP

On Thu, 3 Jun...
Forum: General Discussion June 4th, 2010, 12:26 AM Posted to microsoft.public.excel.misc
Replies: 2
Views: 568
Posted By Gord Dibben
Copy and insert multipel rows after each row of data

You have 100+ rows.

One column or many columns of data?

Each row is to be duplicated 19 times for a total of 1900+ rows when
complete?

You want to do this manually or by code?
Forum: Worksheet Functions June 3rd, 2010, 11:57 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 3
Views: 487
Posted By Gord Dibben
Large list of numbers to concatenate

Function ConCatRange(CellBlock As Range) As String

'=concatrange(range)
'for non-contiguous cells =ccr((a1:a10,c4,c6,e1:e5))

Dim Cell As Range
Dim sbuf As String
For Each Cell In CellBlock
...
Forum: Worksheet Functions June 3rd, 2010, 11:54 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 2
Views: 515
Posted By Gord Dibben
Function to concatenate cells in a range

Function ConCatRange22(CellBlock As Range, Optional Delim As String = "") _
As String

'entered as =concatrange22(a1:a10,"|") desired delimiter between quotes
'or as ...
Forum: General Discussion June 3rd, 2010, 11:31 PM Posted to microsoft.public.excel.misc
Replies: 3
Views: 455
Posted By Gord Dibben
HOW DO I DUPLICATE ONE SHEET MULTIPLE TIMES

Easily done with a macro.

Sub CreateNameSheets()
' by Dave Peterson
' List your 20 names required in col A in a sheet: List
' Sub will copy sheets based on the sheet named as: Template
'...
Forum: General Discussion June 3rd, 2010, 11:21 PM Posted to microsoft.public.excel.misc
Replies: 3
Views: 1,193
Posted By Gord Dibben
Auto Row Height with Wrapped Text in Merged Cells Problem

You need VBA to assist with this.

I would not use merged cells at all if they can be avoided.

See google search thread for code by Greg Wilson. Watch out for word wrap
in the URL which is all one...
Forum: General Discussion June 3rd, 2010, 11:18 PM Posted to microsoft.public.excel.misc
Replies: 11
Views: 663
Posted By Gord Dibben
Remove columns with all zeros

Gord Dibben never suggested a macro.

Gord told you where to store the macro that Gary's Student had posted for
you.


Gord Dibben MS Excel MVP

On Thu, 3 Jun 2010 10:13:51 -0700,...
Forum: General Discussion June 3rd, 2010, 11:11 PM Posted to microsoft.public.excel.misc
Replies: 4
Views: 544
Posted By Gord Dibben
How do I make the drop down list view larger?

Steve

If OP is referring to Data Validation dropdown list there is no font
changing.

8 pt is the only size you get.


Gord Dibben MS Excel MVP
Showing results 1 to 25 of 100

 
Forum Jump

All times are GMT +1. The time now is 02:13 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 OfficeFrustration.
The comments are property of their posters.