Top 11 # Xóa Option Trong Excel Xem Nhiều Nhất, Mới Nhất 3/2023 # Top Trend |

Excel 2013: Freezing Panes And View Options



Whenever you’re working with a lot of data, it can be difficult to compare information in your workbook. Fortunately, Excel includes several tools that make it easier to view content from different parts of your workbook at the same time, such as the ability to freeze panes and split your worksheet

Optional: Download our practice workbook.

To freeze rows:

You may want to see certain rows or columns all the time in your worksheet, especially header cells. By freezing rows or columns in place, you’ll be able to scroll through your content while continuing to view the frozen cells.

Select the row below the row(s) you want to freeze. In our example, we want to freeze rows 1 and 2, so we’ll select row 3.

Select the Freeze Panes command, then choose Freeze Panes from the drop-down menu.

The rows will be frozen in place, as indicated by the gray line. You can scroll down the worksheet while continuing to view the frozen rows at the top. In our example, we’ve scrolled down to row 18.

To freeze columns:

Select the column to the right of the column(s) you want to freeze. In our example, we want to freeze column A, so we’ll select column B.

Select the Freeze Panes command, then choose Freeze Panes from the drop-down menu.

The column will be frozen in place, as indicated by the gray line. You can scroll across the worksheet while continuing to view the frozen column on the left. In our example, we’ve scrolled across to column E.

If you only need to freeze the top row (row 1) or first column (column A) in the worksheet, you can simply select Freeze Top Row or Freeze First Column from the drop-down menu.

Other view options

If your workbook contains a lot of content, it can sometimes be difficult to compare different sections. Excel includes additional options to make your workbooks easier to view and compare. For example, you can choose to open a new window for your workbook or split a worksheet into separate panes.

To open a new window for the current workbook:

Excel allows you to open multiple windows for a single workbook at the same time. In our example, we’ll use this feature to compare two different worksheets from the same workbook.

A new window for the workbook will appear.

You can now compare different worksheets from the same workbook across windows. In our example, we’ll select the 2013 Sales Detailed View worksheet to compare the 2012 and 2013 sales.

If you have several windows open at the same time, you can use the Arrange All command to rearrange them quickly.

To split a worksheet:

Sometimes you may want to compare different sections of the same workbook without creating a new window. The Split command allows you to divide the worksheet into multiple panes that scroll separately.

Select the cell where you want to split the worksheet. In our example, we’ll select cell C7.

The workbook will be split into different panes. You can scroll through each pane separately using the scroll bars, allowing you to compare different sections of the workbook.


Open an existing Excel workbook. If you want, you can use our practice workbook.

Try freezing a row or column in place. If you are using the example, freeze the top two rows (rows 1 and 2).

Try opening a new window for your workbook.

Use the Split command to split your worksheet into multiple panes.


Editing Microsoft Excel And Word Export Options

If performance or Java issues occur when exporting items to Microsoft Excel or Word, you can increase the memory used and change the number of minutes before exports time out. You can also change the Java Runtime to use.

If Java issues occur when exporting from the Classic tab on the Export to Microsoft Word dialog box in the Helix ALM Client, users can increase the memory in the local options. See the Helix ALM help for information about changing general local options.

The Edit Server Options dialog box opens.

Limit memory use to X MB

Maximum amount of memory the Java Virtual Machine (JVM) can use during an export.

4096 MB

Time out export after X minutes

Indicates how long the Helix ALM Server should wait before timing out an export.

5 minutes

Java Runtime path

Windows – 32-bit: jre directory in the application directory (e.g., C:Program FilesPerforceHelix ALMjre); 64-bit: jre64 directory in the application directory (e.g, C:Program FilesPerforceHelix ALMjre64)

Linux – 32-bit: No default. A path must be set. 64-bit: jre64 directory in the application directory (e.g., /var/lib/HelixALM/jre64)

Word Exported Image File Size

In multi-line fields

Indicates how to export images in multi-line text fields to Word. Compress resizes image files to attempt to fit an 8.5 x 11 inch page in the Word document. Full resolution displays images at their full resolution. If an image is resized in Helix ALM after it is added to a field, the image in the resulting Word document is the same as display size in Helix ALM. If the image was not resized in Helix ALM, it scales to fit in the Word document or is displayed at full size if the image it too large to scale.



Indicates how to export images attached to items to Word. Thumbnail displays images as thumbnails in the Word document. Compress resizes image files to attempt to fit an 8.5 x 11 inch page in the Word document. Full resolution displays images at their full resolution. Attachments that are not images are displayed using a generic thumbnail image.


Attachments in test case and test run steps

Indicates how to export images attached to steps in test cases and test runs. Thumbnail displays images as thumbnails in the Word document. Compress resizes image files to attempt to fit an 8.5 x 11 inch page in the Word document. Full resolution displays images at their full resolution. Attachments that are not images are displayed using a generic thumbnail image.


Additional information

If Full resolution is selected as the image file size option:

The memory used by the Word export process will be impacted, which may prevent the export from completing successfully.

PNG files are not automatically scaled in the exported document. JPG files only automatically scale correctly if they are 96 DPI in Helix ALM.

If Compress is selected as the image file size option, all image files are converted to .jpeg files in the exported document, regardless of the file type in Helix ALM.

If images are not displayed as expected in the Word document, see the Helix ALM help for more troubleshooting information.

Is There A Word Stronger Than Love? (5 Possible Options)

Are you looking for a word that is stronger than ‘love’ to say to your partner?

Do you think there’s an alternative word that’ll describe your feelings better?

Maybe you can’t think of the perfect word to use?

If so, you’re in the right place, because we have listed five fantastic alternatives to use.

However, before we explore what these words are, I want to share an important story.

Throughout my twenties, I was stuck in relationships where we weren’t really sure if we ‘loved’ each other.

Looking back, this was mostly my fault.

I wasn’t really doing enough to make a lasting impression on these men. Within a few months, they’d get bored of me and leave.

Thankfully, I managed to turn this around… and it all started when I learned about a powerful aspect of male psychology.

It’s called the ‘Hero’s Instinct’ – and it has a huge impact on how they feel about the women in their life.

When I learned how to trigger this way of thinking in a man, it would often trigger deep feelings of longing and affection. I could make him feel fulfilled in a way that no other woman could (read my personal story to learn moreIf you’re hoping to enjoy deeper, more fulfilling relationships, I’d recommend you read how I discovered the power of the ‘Hero’s Instinct’. ).

It’s an easy skill to learn, yet so few people seem to know about this.

Read on for our five alternatives to ‘love’.

‘Love’ as a descriptive word is powerful but sometimes misused – it seems to convey different things to different people and I think can be rather generic. Is love suffering from word exhaustion?

I think the word ‘love’ is often used when there is a better, more precise alternative. Stop bandying love around! Here are my choices for your romantic vocabulary which might just hit the mark better than love, actually.

Let’s get physical! Initial attraction is usually a physical sensation and the science is there to prove it.

Attraction is chemical and its all in the mind, regulated by the hypothalamus in the brain which controls the sex hormones. Now you understand why that perfect match on Tinder just didn’t excite you in the slightest when you met. There was no chemistry.

Freud believed that sex drive was the most powerful governing force in the life of the human being. So when we say love at first sight, are we actually referring to something chemical and should we be saying, lust at first sight? The pink haze of love is seen firmly through rose-tinted glasses. Some pundits believe that the concept of love at first sight is retrospective, the early encounters in people’s minds, a warm interpretation colored by reminiscence.

Lust is such an onomatopoeic word though. It might be a word you use to describe your feelings to a third party, not directly to the one you actually lust after. “If they substituted the word ‘Lust’ for ‘Love’ in the popular songs it would come nearer the truth.” Thank you, Sylvia Plath for that truism.

2. Affection

Affection is a subtle word, bypassed these days for louder, more vivid sentiments. But the subtlety of affection can make it the perfect bon mot on the right occasion.

Affection conveys feelings of warmth, depth and an intimacy created by a deep underlying love that has matured like a fine wine. Affection is the ultimate expression of love and a deep love that endures the trials and tribulations of life.

Affection is not so much a word you might use but us borne out by demonstrable actions.

Affection can be the smallest but most significant token. Barack and Michelle Obama always displayed their affection for each other publicly, a clear demonstration of the strength of their relationship and a deep, powerful love. Now say you can’t make time – if the former President of the USA can then you can!

A thoughtful gift doesn’t have to be expensive, how about always giving your partner your full attention when it is something that matters to them and my personal favorite, touch. Just a casual brush of the hand or stroke of the cheek or a ‘for no apparent reason’ text or email.

These little touches, literally, won’t cost you anything in terms of time or money. Affection resonates, it is the glue that bonds two people together. Relate, the marriage guidance people, call it ‘ love language ‘ and emphasize how important it is to any relationship.

This word is my personal favorite. I just can’t say ‘desire’ without injecting a tone of voice and resonance that wouldn’t’ sound out of place in a television audition for a costume drama. You know the type of thing, smoldering looks, provocative bodices and heaving bosoms.

Desire speaks volumes in an understated yet powerful language. It is more comprehensive and multi-faced than lust. Desire suggests both a mental and physical engagement, a sublimation of all the senses and emotions, is desire the herald of true and meaningful love?

The word ‘desire’ conveys a strength that ‘love’ also just one syllable cannot. Desire is often combined with adjectives such as ‘burning’ or ‘powerful’. Desire relates to both an emotional and physical connection, an all-encompassing overwhelming emotion. George Bernard Shaw said, “There are two tragedies in life. One is to lose your heart’s desire.”

Desire or Desiree believe it or not used to be a popular choice as a girl’s name. Perhaps more commonly seen in the States than in the UK, this possibly harks back to the popularity of the name amongst the Puritans of New England. And you thought it was just the name of a type of potato or an American streetcar!

La Grande Passion! For the liqueur connoisseurs amongst you, this might hark back to the later decades of the last century and a vague memory of a select tipple from the makers of Grande Marnier and Cherry Marnier. And the title has also been used by Andy Warhol rather disappointingly to depict a painting of that very liqueur rather than something more romantic. Both, it would seem, command a very high price but what does ‘la grande passion’ convey in the true meaning of this phrase?

Passion is not just used in the context of love but has a real connection to suffering so perhaps an anguished love. In religious terms, Christians refer to the Passion of Christ, a love so great for mankind that he gave up his life. Passion means self-sacrificing possibly even pain, love so powerful that it hurts. The derivation of the word comes from the Latin, pati, which means to suffer, to endure and in modern parlance, the use of ‘passion’ has moved away from this heartfelt sense of anguish into something a little more limited. There is a distinct vein of madness in real passion as coined by William Wordsworth, the English romantic poet, in his ballad, ‘Strange fits of passion have I known’. Passion implies a temporary suspension of sanity and reality, a momentary blindness. 5

Perhaps in the sequence of phases, ardor should sit before lust and after desire. Ardor implies a sense of earnestness, a zeal, an intensity to pursue and to woo. There are a fervency and pace about ardor which makes the word ‘love’ seem rather static in comparison.

Ardor might apply to the early stages of a love affair, the heady ascendency of the chase and early engagement before the deep plunge into the tumult of a really passionate affair.

Ardor is a rather old-fashioned word, both emotional and emotive and seems to sit alongside, ‘amour’ which is French for love and ‘arbor’ which is used to represent a peaceful, shaded area in a garden where lovers might meet. Arbors have become very popular at weddings, particularly ceremonies taking place in the great outdoors where there can be a lack of physical focus or centre. Even couples getting married in church may opt for an arbor at their wedding reception, to act as a focal point for photographs and when guests gather.

I guess the thing about ardor is that it doesn’t have to mean love in a romantic context although this is where it is usually employed. Ardor can mean zeal or enthusiasm for a cause that has nothing to do with affairs of the heart. Because of this, ardor might suggest a disconnected love, an unrequited affection that is not even known about, a totally anonymous devotion. It has connotations of reverence and admiration which indicate a love on a higher plane.

Perhaps ardor is just descriptive of a type of love therefore or a characteristic of a love developing between two people.


Being a bit of a word snob, I have an inherent distaste of using the wrong word in a particular context. I believe that the word ‘love’ is overused, devalued in word currency when a better selection could convey more accurately what you feel. Hasn’t the word ‘love’ become just a bit passe?

Cách Xóa Password Trong Excel 2007

Nhu cầu bảo mật nên chúng ta thường đặt mật khẩu cho file Excel để bảo vệ các số liệu tính toán. Nhưng nếu chẳng may quên mật khẩu đã thiết lập thì thật phức tạp. Bài viết sau sẽ hướng dẫn bạn cách thức “chữa cháy” trong trường hợp này.

Làm gì khi quên mật khẩu của file Excel?

Tương ứng với file Excel đã được đặt mật khẩu bảo vệ Sheet hay Workbook, bạn chọn hình thức gỡ bỏ passwork thích hợp.

Trong quá trình thử nghiệm, người viết đã thử đặt một mật khẩu phức tạp, bao gồm cả chữ thường, chữ in hoa, các kí tự số… Excel Passwork Remover sẽ mất khoản 2 phút để hoàn thành công việc của mình. Khá nhanh chóng và hiệu quả. Sau khi công việc hoàn thành, 1 cửa sổ sẽ hiển thị để thông báo cho bạn biết. Bây giờ, bạn có thể thay đổi nội dung bên trong các Sheet và Workbook của Excel mà không gặp bất kỳ vấn đề nào về mật khẩu.

Nếu muốn dùng phiên bản đầy đủ, bạn có thể tìm thấy chương trình tại các cửa hàng tin học.

Hy vọng, với những tiện ích ở trên, bạn sẽ tìm ra được biện pháp hiện quả để tạm thời khắc phục hậu quả cho sự “đãng trí” của mình.

Cách 3:

Dùng tiện ích Excel Password Remover 2009 (ER09): một add-in của Excel giúp loại bỏ mật khẩu bảo vệ các Sheet hay Workbook để chống thay đổi nội dung. ER09 tương thích với Excel 2000, XP and 2003, được cung cấp miễn phí ở địa chỉ: sau đây

Cách 4:

Dùng đoạn mã Visual Basic:bạn cũng có thể tự tay xóa mật khẩu bảo vệ các Sheet mà không cần dung đến ER09, cách thực hiện như sau: Mở file Excel, nhấp phải chuột lên Sheet đã được bảo vệ chọn View Code. Cửa sổ Microsoft Visual Basic xuát hiện, bạn dán đoạn mã sau:

Sub PasswordBreaker() Dim i As Integer, j As Integer, k As Integer Dim l As Integer, m As Integer, n As Integer Dim i1 As Integer, i2 As Integer, i3 As Integer Dim i4 As Integer, i5 As Integer, i6 As Integer On Error Resume Next For i = 65 To 66: For j = 65 To 66: For k = 65 To 66 For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66 For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66 For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126 ActiveSheet.Unprotect Chr(i) & Chr(j) & Chr(k) & _ Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _ Chr(i4) & Chr(i5) & Chr(i6) & Chr(n) If ActiveSheet.ProtectContents = False Then ActiveWorkbook.Sheets(1).Select Range(“a1”).FormulaR1C1 = Chr(i) & Chr(j) & _ Chr(k) & Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & _ Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n) Exit Sub End If Next: Next: Next: Next: Next: Next Next: Next: Next: Next: Next: Next End Sub

Nếu bạn có 01 hòm thư Gmail thì bạn có thể dùng để dăng nhập dịch vụ Google Docs. Tệp tin excel của tôi sau khi đặt mật khẩu bảo vệ thì không thể sửa được.

Tôi sẽ tải tệp tin này lên Google Docs để loại bỏ mật khẩu trên sau đó tôi sẽ tải về máy tính của tôi tệp tin vừa tải lên rồi lưu lại với tên khác với tệp tin gốc.

Google Docs có thể sẽ thay đổi một vài khoảng cách của các ô (cell) nên bạn chỉ cần chỉnh lại trên tệp tin đã bị loại bỏ mật khẩu.

Zoho Sheet cũng làm việc tương tự Google Docs nhưng có thêm một vài tính năng khác như chỉnh sửa tệp tin excel được lưu trên SharePoint. Bạn có thể dùng chính hòm thư Gmail của bạn để đăng nhập dịch vụ Zoho Sheet. Sau khi đăng nhập bạn tải tệp tin cần loại bỏ mật khẩu như hình dưới.

Sau đó vào mụcExport để lưu tệp tin với tên khác với tệp tin gốc bị đặt mật khẩu thành nhiều định dạng như định dạng .ods (OpenOffice), .xls (Microsoft Office 2003), .xlsx (Microsoft Office 2007), .pdf….

Xóa bỏ protect, password ở file Exel

Bạn là dân kế toán, hoặc đang soạn thảo một tài liệu quan trọng nào đó, bạn đã đặt password bảo vệ cho file exel này của bạn, nhưng đôi khi bạn quên mất password mình đã đặt là gì dẫn đến bạn không thể xem hoặc chỉnh sửa lại nội dung trong file exel đó của bạn.

Cách xóa password, unproteced file exel sau đây sẽ giúp các bạn vô hiệu hóa chức năng đó của exel, và bạn có thể chỉnh sửa, xem file exel của bạn thoải mái. Cách này quá đơn giản so với việc dùng phần mềm dò password file exel.

Hiện ra bảng như hình dưới:

Bạn chờ khoảng 5s để đoạn Macros làm việc.

Password của file exel sẽ được hiện lên, bạn hãy ghi lại nếu cần:

Cuối cùng, thông báo hiện lên toàn bộ password, protected của worksheet của file exel đã bị vô hiệu hóa, ban có thể chỉnh sửa thoải mái rồi đấy.