Lyte Byte - Byte of Technology, Computers, Internet, Web 2.0, Tips, Tweaks
Here is another small tip for Microsoft Excel. Many at times, the data is presented in different format in different Excel sheets and while moving the data from one sheet to another imposes copying the date from a row to a column or from a column to a row.
It’s easier to just convert using the Transpose function but it may be little tricky while using functions and formulas.
So how to copy the data from a row to a column or vice versa?
Its been a while since I write the post on the series ‘The Best of Last Month‘ and I thought it would be appropriate to start it again.
If you have missed any top posts over the last month, here is the top 5 from April 2008.
My new mobile phone helped me to write Nokia N95-4 8GB review which has become one of the top post of Lyte Byte. These days, I am writing more on Excel Tips. Although I am planning to write more on other Office Applications like Word and Powerpoint and also more on free applications for Vista. Stay connected for the upcoming How-to tips and tweaks.
As a reader of Lyte Byte, what is your suggestion? Should I diversify the topics covered or should I just concentrate on one field?
In the last post on reference style in Excel, I discussed about A1 and R1C1 reference style. Sometimes its necessary to switch between these two reference style for easy usage, but how to change between A1 and R1C1 reference style?
This option is different in Office 2003 and in Office 2007.
Did you ever get lost with too much of functions and commands in Office 2007 ribbon? Or did you ever blame that you were not able to find the command that you wanted to use in Office 2007? Well, here is the solution to all that! Its Search Commands from Office Labs.
Search Commands was just recently released by Microsoft which is a part of Office Labs project. You need not wonder where is the command you are looking for anymore. All that you have to do is start typing the name of command or the description of the command that you might be looking for and Search Commands starts to display all the possible commands you might be looking for. Search Commands works with Word, Excel and PowerPoint from Office 2007.
Download Search Commands for Office 2007
There are two types of reference styles in Excel. The first one is A1 reference style where the columns are labeled using the Alphabets and the rows are labeled using numbers. In the R1C1 reference style both the rows and columns are labeled using numbers. Earlier versions of Excel from MS Office came with only R1C1 reference style. But recent versions like Office 2007 has both referencing styles.
For example, in A1 Reference Style, E15 refers to the cell in 15th row and Eth (5th) column and the same cell in R1C1 Reference Style uses R15C5 (R followed by the row number and C followed by the column number).
After writing the post on How to delete Folders in Google Reader, I found that many people are searching for how to delete folders in Yahoo Mail. The folders in Yahoo Mail are very helpful to organize different mails and aids in easy retrieval. I just realized that I have created 42 folders to manage my inbox and it would be really great if they support nested folders like in Outlook.
In the new Yahoo Mail, deleting or adding a folder is very simple. As all that you have to do is right click in the folder area. I guess many are not aware that right clicking at the folders or mail in Yahoo Mail doesn’t activate the regular Windows Options but its own Yahoo Mail Options. This works both for the folders and within mails. Read the rest of this entry »
Whether one like it or not, Windows Vista is one of the high memory resource intensity operating system that is available. Most of the applications that are running are set to improve the aesthetic look of the Windows by Visual Effects and are not necessarily adjusted for performance. If you have low memory (RAM) in your PC, you may want to change these settings from best appearance to best performance or you may want to choose settings manually. By doing this, one can greatly improve the performance of Windows Vista PC.
So how to adjust the settings in Windows Vista from best appearance to best performance?
About Lyte Byte & Me
Bringing you Tips, Tutorials, and Tweaks on Computers, Internet, Operating System, Windows Vista, Office Applications, Web 2.0, Gadgets, Science, and Technology.
Its a byte of technology, did you have your byte today?
subscribe through Email
Recent Comments