Search in pcbugz

Custom Search

Tuesday, March 31, 2009

HOW TO FREEZE THE FIRST COLUMN & ROW ON A SPREADSHEET

In MS Excel, there is this thing called FREEZE PANE. You can use this mainly for freezing a row or a column for easier scrolling through the sheet. What if I wanted to freeze the top row and the leftmost column? How do I do that?

1. Click on B2. This is the cell to which scrolling from top and from left will stop.
2. Go to View, Select Normal
3. Click on Freeze Pane

From this moment, when you scroll down, row 1 will not be out of sight, and when you scroll right, the first column will still be visible.
You can add additions to this like 2 rows and 1 column only, or 3 columns and 1 row, etc, whatever you prefer. Make sure to highlight the cell that will separate the stationary versus the moving cells.
Easy? Yup.


...to end: count then share your blessings to others...

Friday, March 6, 2009

MAC APPLICATIONS

The store manager then asked me “do you know technical things?”
“Yes”, I answered him back.
“Then why can’t you tell the guy what can Mac computers do?” he questioned again.
“The thing the customer is asking is what applications there are in Mac that is different with Windows. I have limited knowledge when it comes to Mac,” I said.
Then he moved out.

As if he I have to know everything. I'm only human. If the customer has time back then, I can look it up on the internet and answer his questions. It’s just that these people are so intense in giving the customer top of the line services when they cannot give it a 100%. Their catalogs are incomplete, the specifications of a computer is incomplete too, and their salesmen don’t know anything about the technical specifications of a device, when in the first place, they should know a little of it, at the least.

That is not the reason I am here. I am here to give justice to an ailing computer, to repair. And not give the technical specifications and what this specific device can do and so on abruptly. It’s like it’s my fault that the customer didn’t purchase the Mac notebook because of me. There are hundred applications! I’m so pissed off with that manager.

For those of you who doesn't know the application a Mac can have, this site is for you. Go and check this link.


...to end: count then share your blessings to others...

Sunday, March 1, 2009

DELL FACTORY IMAGE RESTORATION

I have post for recovering the computer in factory settings FOR DELL COMPUTERS ONLY with WINDOWS XP operating system. This time, I have for Windows Vista. Make sure you know the administrative name and password.
1. Restart the pc, when you see the Dell logo screen
2. Tap F8 until you see Advanced Boot Options menu
3. Select Repair Your Computer then enter
4. Select Language then Next
5. Type the administrative name and password in the box
6. Select DELL FACTORY IMAGE RESTORE, Next
7. Choose Yes to reformat the HDD into factory defaults, when finish, restart pc
Whatever software you installed on the computer, including all your files will be deleted due to reformatting. I suggest for you to back up your files first before doing the above steps. Although when the pc is reformatted, whatever software that was included when you purchased the computer will be there.


...to end: count then share your blessings to others...