Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Could you help me with using Excel?

01 Jun 2014   #1
mangoh

Windows 7 Professional 64bit
 
 
Could you help me with using Excel?

All the things I need help with have been mentioned on the Excel document.

I created a example spreadsheet.

Please could someone help?

https://www.dropbox.com/s/6ns561feblzolaj/example.xlsx


My System SpecsSystem Spec
.
01 Jun 2014   #2
TanyaC

Linux Mint 17 Cinnamon | Win 7 Ult x64
 
 

Hi,

To see today's day use the function =Today() and under format cells select a custom format and put in 4 d's. Eg. dddd. That will make the cell show the day of the week.

To have multiple people able to access the spreadsheet at the same time go to Review > Share Workbook, and tick the check box for "allow multiple users to update..."

Then click on the advanced tab. Under Update changes select "Automatically" and set the number of minutes you would like the spreadsheet updated.

hth
Tanya
My System SpecsSystem Spec
10 Jun 2014   #3
mangoh

Windows 7 Professional 64bit
 
 

Quote   Quote: Originally Posted by TanyaC View Post
Hi,

To see today's day use the function =Today() and under format cells select a custom format and put in 4 d's. Eg. dddd. That will make the cell show the day of the week.

To have multiple people able to access the spreadsheet at the same time go to Review > Share Workbook, and tick the check box for "allow multiple users to update..."

Then click on the advanced tab. Under Update changes select "Automatically" and set the number of minutes you would like the spreadsheet updated.

hth
Tanya
Thank you for your response.

Anyone know the answers to the other questions?

Also the answer to this additional question...

I created an in cell drop-down menu, you only realise it is a drop-down menu when you click the cell as the down arrow shows.

Is it possible to have the down arrow showing permanently so users are aware it is a drop-down menu before actually clicking the cell.
My System SpecsSystem Spec
.

10 Jun 2014   #4
TanyaC

Linux Mint 17 Cinnamon | Win 7 Ult x64
 
 

Quote   Quote: Originally Posted by mangoh View Post
Anyone know the answers to the other questions?
I thought I'd covered all of them. What did I miss?

Quote   Quote: Originally Posted by mangoh View Post
I created an in cell drop-down menu, you only realise it is a drop-down menu when you click the cell as the down arrow shows.

Is it possible to have the down arrow showing permanently so users are aware it is a drop-down menu before actually clicking the cell.
Using data validation "list" - No you can't. Using form controls and VBA code, yes you can.

I generally just insert a down arrow in the adjacent cell, and use a description of "Select xyz:" so it becomes apparent that it is a select list. I agree, it is a pain in the bum.
My System SpecsSystem Spec
11 Jun 2014   #5
mangoh

Windows 7 Professional 64bit
 
 

Quote   Quote: Originally Posted by TanyaC View Post
Quote   Quote: Originally Posted by mangoh View Post
Anyone know the answers to the other questions?
I thought I'd covered all of them. What did I miss?

Quote   Quote: Originally Posted by mangoh View Post
I created an in cell drop-down menu, you only realise it is a drop-down menu when you click the cell as the down arrow shows.

Is it possible to have the down arrow showing permanently so users are aware it is a drop-down menu before actually clicking the cell.
Using data validation "list" - No you can't. Using form controls and VBA code, yes you can.

I generally just insert a down arrow in the adjacent cell, and use a description of "Select xyz:" so it becomes apparent that it is a select list. I agree, it is a pain in the bum.
Erm the refresh button as the idea is a user presses this button prior to making a call as then it shows them if someone is available.

Also any ideas on automatic input for availability.

Also thanks, I'll use a combo box for the drop-down menu.
My System SpecsSystem Spec
11 Jun 2014   #6
TanyaC

Linux Mint 17 Cinnamon | Win 7 Ult x64
 
 

Hi,

Sorry, I thought the auto update interval on the sharing dialogue would suit your needs. Since, every time it updates the workbook, it also refreshes what you see (that is, it behaves exactly like a refresh button).

Look at the image below; The "And see others' changes". This is effectively a refresh option.

A refresh button can be achieved using VBA code. What it would do is load the worksheet from it source location. But since it is possible there are unsaved changes, it must first save the workbook.

The code would go something like this...

'below code for saving and closing the workbook
Workbooks("book1.xls").Activate
ActiveWorkbook.Save
ActiveWorkbook.Close

'opening workbook
Workbooks.Open Filename:="c:\book1.xls"

---
You must activate it before attempting to close it. Insert full path to file name.

Now, as to automatically inputting availability;

This implies that there is a fixed availability list. Where does this availability come from? If it's automatic it has to be stored somewhere. If it's static you would just update it and save the sheet.

If you want them to have the same availability for the whole week, then just get them to enter the first day and use formulas to replicate the availability across the rest of the week.

If I am on the wrong track, please explain what you mean by "automatic availability".


Tanya


Attached Images
Could you help me with using Excel?-sf2.jpg 
My System SpecsSystem Spec
Reply

 Could you help me with using Excel?




Thread Tools Search this Thread
Search this Thread:

Advanced Search




Similar help and support threads
Thread Forum
How to go back from Excel 2010 64 bit to Excel 2010 32 bit
I have an important program that uses a DLL that only works with Excel 2010 32 bit. I'm running Excel 2010 64 bit now -- how do I install the 32 bit version? I have the CD which has both versions on it. But when I run Setup, it gives me options that I don't understand for this limited purpose. In...
Microsoft Office
Excel And .CSV ?
Hello, I have created a small Excel file that I wish to be saved as a CSV. Question: do I have to put " marks around the beginning, and end, of the text in each cell, or does Excel automatically do what is required for CSV when I tell it to Save As a CSV ? I did Not put any " marks around...
Microsoft Office
Formatting Excel 2010, Excel 2003
Hello, I want to create a table as in the drawing below, where the first cell is table-wide (as it contains the heading common (pertaining?) to all columns and rows under it) but, and this is where I cannot get it together, where those cells are divided into several columns. It's a cinch when...
Microsoft Office
Excel?
Hi, Maybe a bit of off-forum, but how do you make that column A en B show on every sheet (not printed) of my excel workbook? I got Name and First Name, and I want to have that shown at every new sheet I make without having it to copy each time and when I change something at my first sheet, the...
Software
Can't open 2003 Excel Files in Excel 2007?
I'm not sure if it because the files are 2003 or not? When I try to open them an error message appears stating, "...the file you are trying to open is in a different format than specified by the file extension. Verify file is not corrupted and is from a trusted source..." These are my files. The...
Microsoft Office
Excel 2003 - Multiple Excel Open
Hi All, I don't know if I'm posting in the right area but I really need help. Before (In XP and Vista), when I have one excel file open and I go to desktop to open a different excel, it would open in the same excel program (2 files in 1 program) With Windows 7, when I open a different file, it...
Microsoft Office


Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 03:43.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App