Switch Excel Rows to Columns

paste special transpose dialog

{lang: ‘ar’}In Excel Transpose is a Function used to switch the columns and rows. It switches the columns cell values as rows and vice versa. Transpose can be done by the following methods (1) Using Paste Special and (2) Using Function TRANSPOSE Using Paste Special Consider the example below. We will switch the column headings [...]

Using Line Numbers in Word 2007

Line Numbers

{lang: ‘ar’}Overview Depending on the type or purpose of documentation, you may need to have line numbers along the margin for each line. For example, you may be submitting an article for publication where the article has to be within the specified line numbers. Word facilitates Line Numbers; this article outlines the steps and applies to Word 2007 [...]

Create Password Reset Disk Windows 7

trans2.gif

{lang: ‘ar’}Introduction Good security policy dictates that the user be forced to change passwords every 90 days. Additionally, security rules necessitates that the passwords be of a certain length, contains alphanumeric characters, and previously used passwords (within a certain time frame) cannot be reused. These are applicable at work and it is a good practice [...]

Using Quick Parts in Word 2007

Quick Parts

{lang: ‘ar’}Introduction In Word 2007 Quick Parts help save text or images that can be reused later with minimal key strokes. For example, inserting a standard disclaimer in the documents, or company’s web address, or even headers and footers that have to be in standard format in all documents. The Quick Parts can also be [...]

Footnotes and Endnotes Word 2007

footnote and endnote

{lang: ‘ar’}Footnotes and Endnotes are placed in a document to acknowledge or cite a reference or to note an explanation by the author etc. Footnotes are generally placed at the bottom of the same page and Endnotes are placed at the end of the document. Steps – Setting up Open References tab in Word 2007 [...]

SharePoint Team Discussion Dashboard Web Parts

subject view

{lang: ‘ar’}Overview In a SharePoint Team Discussion Board you can create columns to monitor items based on Priority (Low, Medium, High) or Status (Open, Closed). The columns get displayed in the Subject view. Though helpful, it does not give a quick snapshot especially if the feedback list has several items. One way to get a [...]

How to sort table in Word 2007

table sort

{lang: ‘ar’}Overview A sort can be performed on a table according to the type or other common element of the data. For example, a table having apples and oranges can be sorted on the type of fruit or a column with first and last names can be sorted on last names This article outlines the [...]

Autonumber Writer Table in OpenOffice.org

table numbering in writer

{lang: ‘ar’}Overview The Numbering feature in OpenOffice.org Writer can also be extended to number tables in Writer. If you are working on a table with several rows, use the Numbering feature and avoid manual insertion of numbers. The autonumber feature also changes the number suitably for any row inserts. For Word 2003 steps, click here. [...]

Resolve out of memory error in WordPress updates

{lang: ‘ar’}WordPress updates can either be updated automatically or downloaded and installed. The automatic updates are quick and easy generally and issue arises if there is not sufficient memory In such cases the updates fail with a message similar to the one below Out of memory (allocated 29884416) (tried to allocate 3096504 bytes) Resolution Increasing [...]

Create online approval form in SharePoint

approval columns

{lang: ‘ar’}Overview In an Organization approval of the key stakeholders is required for various tasks such as the project plan, design document, user documentation etc. The approval can be either a physical signature or it can be in electronic form.  This article outlines using SharePoint (2007, 2010, or even 2003 versions) to capture the approval [...]

Page optimized by WP Minify WordPress Plugin