sifar786

@sifar786 (35)

India • Age 50

Joined myLot 17 years ago

Open Source for all!

Discussions (18)

Responses (5)

sifar786's Responses

Excel Help

dragan80 @dragan80 (920) • Italy 22 Feb 07

Can I create drop down menus in excel and how? Im doing a nex excel sheet and would like to create a list of all the styles I produce in a drop box so that the staff can just choose the style rather than writing it out. I...

drop down menus

1 response •

1 person

sifar786 Sure you can create dropdown menus in a worksheet. Consider 2 worksheets Sheet1 & Sheet2. Let take sheet2 first. This will be your database sheet where you can enter all the styles in Column A & their respective prices in column B. Select all the styles...

23 Feb 07

•

1 comment

•

1 person

Excel problem

zugedanit @zugedanit (1958) • Philippines 15 Feb 07

I'd like a bit of entry information for both Excel and Access. When I am typing in a field the first time, I type the whole word. When I type the same word subsequently, I would like for the word to complete itself after the...

2 responses •

1 person

sifar786 Hi Dude, I guess what you are referring to is the Autocomplete feature in Excel & Access. All you have to do is to ENABLE it by clicking, -TOOLS menu -select OPTIONS -select EDIT TAB -put a tick inside ENABLE AUTOCOMPLETE FOR CELL VALUES Hope...

20 Feb 07

Dashboards in Excel

ShahidKhan1479 @ShahidKhan1479 (1522) • India 24 Nov 06

Anybody know how to make Dashboards in Excel? I wanted to make it. Pls revert back if know or if u can help me in any way. Awaiting your response...

7 responses •

1 person

sifar786 Hi Shahid, Let me know what type of dashboard u are making, maybe i can be of help to you. Cheers! Sifar http://sifar.ueuo.com

20 Feb 07

•

1 person

area 51

nhot2arenas @nhot2arenas (70) • Philippines 10 Feb 07

Is there really a place cALLED AREA 51?.is it true that extra terrestials that have discovered was kept in here?

4 responses •

2 people

sifar786 Yes. Area 51, also known as Groom Lake, is a secret military facility about 90 miles north of Las Vegas. The number refers to a 6-by-10-mile block of land, at the center of which is a large air base the government will not discuss. The site was selected in the...

20 Feb 07

excel shortcuts

nhot2arenas @nhot2arenas (70) • Philippines 7 Feb 07

can anyone here help me give some keyboard shortcuts for MS Excel!?plss!!i just want to do everything on it without relying too much on my mouse!tnx guys!

4 responses •

2 people

sifar786 Hi friend, Here is a list of Excel shortcuts for you. Incase you need the full shortcuts, i have posted them on my website in the EXCEL folder. You can visit, http://sifar.ueuo.com Cheers! Eijaz SHIFT+F11 or ALT+SHIFT+F1 Insert a new...

20 Feb 07